SELECT ite.item_id, ite.user_id, ite.category_id, ite.subcategory_id, ite.title, ite.des, ite.latitude, ite.longitude, ite.area, ite.city, ite.state, ite.country, ite.price, ite.reference_id, ite.time, ite.is_available, ite.sold_at, ite.is_status, ite.is_deleted, ite.user_type, ite.admin_id, ite.feature_first_place, ite.feature_first_page, ite.user_package_rel_id, ite.ads_updated_date, ite.reject_ad_reason, ite.thumb_id, ite.thumb_image, ite.create_at, ite.view_details_count, ite.view_phone_count , IF((SELECT count(*) FROM user_package_rel AS up WHERE up.user_id=ite.user_id AND datediff(DATE_ADD(up.created_at, INTERVAL up.visibility_day DAY), CURRENT_DATE()) ), 'Y', 'N') as is_featured_ad ,0 AS distance_in_km FROM items ite
JOIN categories as tmi ON ite.category_id=tmi.category_id
JOIN sub_categories as tsi ON ite.subcategory_id=tsi.subcategory_id
WHERE
(ite.is_available='Y' OR DATEDIFF(CURRENT_TIMESTAMP, ite.sold_at)<=2 )
AND ite.is_status='Y'
AND tmi.category_id = 6
HAVING distance_in_km < 500
ORDER BY is_feature_ad ASC, feature_first_place ASC, distance_in_km ASC , ite.item_id DESC LIMIT 0, 14
0 0
Try tor
Athani, Karnataka, India
Tryctor
Athani, Karnataka, India
Athani.posat.chikkatti mobile no 9108095467 Read More
Tractor for cultivation
Hulikere, Karnataka, India
Tractor for rent
Harohalli, Karnataka, India
Generators
Hosakerehalli,Bangalore Urban
Generators 9916505290
Hosakerehalli,Bangalore Urban
We deal in generators from 10kva to 250kva Read More
It works on solar and electricity both.delivery free all over India.Contact 9087138981 Read More
Seall.cno.9972811210
Sunkadakatte,Bangalore Urban
All.dakumen runig good condisn...cont vasantgowda...9972811210 model..2013..november end Read More
Jay incubators
Manewada,Nagpur
We r manufacturer of poultry incubators in nagpur, for querru cal me on my no 7709778021/8668617005 Read More
Accessorial Poultry and Fishery equipment marketing and sales
Dhantoli,Nagpur
We present ourselves as ASAN Marketing Solutions having expertise in machinery and equipment marketing and sales in food industry (poultry and and fishery mainl Read More
Organic tillage
Srinivaspur,Bangalore Urban
Bajarangi
Srinivaspur,Bangalore Urban
Maruthi krushi udyog bajarangi
Srinivaspur,Bangalore Urban
Samala Hareendar Reddy
Pendlimadgu,Ranga Reddy
Facebook
Google
