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
Cross gawaran chicken
Khopadi Bk., Maharashtra, India
Cross gawaran with good quality meat Read More
Naati breed hori pair
Kaggalipur, Karnataka, India
Shihtuz female puppis for sale
Hyderabad, Telangana, India
Shihtuz and female puppies
Show
Quite
Deworming
Done
Top aunty
+91888676.1188 Read More
Tejash K j
Baichanalli,Kodagu
Kadaknath,duck,rir,all desi chikas
Chachu Majra, Punjab, India
सबी किसम के मुरगी,टरकी ,बतख ,चकोर ओर बटेर के बचो के लिये सपरक करे फोन,9888281018
Chachu Majra, Punjab, India
सबी मुरगी की देसी नसल के बचे हमारे पास है Read More
Kadaknath chicken
Belgaum, Karnataka, India
kadaknath live chicken 4 months old. Read More
Turkey meat and chicks
Kolkata, West Bengal, India
All types of turkey. Kadaknath, desi murgi, chicks and adults are available here. Read More
DAIRY FARM FOR RENT
Goraghatta, Karnataka, India
ಬಾಡಿಗೆಗೆ ಡೈರಿ ಫಾರ್ಮ್/ DAIRY FARM FOR RENT ONLY:
Advance :1,00,000/- and Rent :10,000/-.
COW SHED Capacity upto 25 Cows + Read More
Broiler chicken
Anand, Gujarat, India
We sell eggs at paper rate from directly our farm nearby Jagtial. Read More
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
Facebook
Google
