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
#india #USA we supply puppies (( ShihTuz Puppies For Sale)) Cell : +918106677888WhatsApp :+918106677888
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
#india #USA we supply puppies
(( ShihTuz Puppies For Sale))
Cell : +918106677888
WhatsApp :+918106677888 Read More
#india #USA we supply puppies (( Malates Puppies For Sale))
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
#india #USA we supply puppies
(( Malates Puppies For Sale))
Cell : +918106677888
WhatsApp :+918106677888 Read More
ShihTuz Puppies For Sale
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
Shih-Tuz
male and female puppies
available
contact +91+919052199325 Read More
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
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
Facebook
Google
