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 = 9
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
Tejash K j
Baichanalli,Kodagu
Ganesh
Gambyapur, Karnataka, India
Desi & देसी क्रॉस चूज़े उपलब्ध हे
Bhopal, Madhya Pradesh, India
Day old chicks rir . Dp. Dp cross
Broiler
Kuroiler
All poultry chicks Read More
Tagaru mari bekagive
Bengaluru, Karnataka, India
Naati breed hori pair
Kaggalipur, Karnataka, India
Shih-tuz female puppies for sale
Hyderabad, Telangana, India
Shih-tuz female puppies for sale
Call
Dis number
8106677888 Read More
Top quality german Shepard puppy
Bhopal, Madhya Pradesh, India
Top quality german Shepard puppy for sale Rollins dog Read More
Shih-tuz female puppies for sale
Hyderabad, Telangana, India
Shih-tuz female puppies for sale
Deworming
Quity
Show
8886761188 Read More
Shih-tuz female puppies for sale
Hyderabad, Telangana, India
Shih-tuz female puppies for sale
Deworm
Done
Show quity Read More
Shihtuz female puppis for sale
Hyderabad, Telangana, India
Shihtuz and female puppies
Show
Quite
Deworming
Done
Top aunty
+91888676.1188 Read More
Cows for sale
Rajaji Nagar,Bangalore Urban
We supply all types of cows throughout india so plz call 9845661012 or 9743048555
Koushik dairy farm and cattle suppliers Read More
Pure Boer blood line. Per kg RS.1200/- Read More
Hyderabadi goats
Kaval Bairasandra,Bangalore Urban