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 ,111.045 * DEGREES(ACOS(COS(RADIANS(26.449923)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.3318736)) + SIN(RADIANS(26.449923)) * SIN(RADIANS(latitude)))) 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'
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
Kadaknath Chicken ,mo -6390090174
Mugishapur,Kanpur Dehat
Om agri junction
Salon Bazar,Rae Bareli
Hamare yanha sabhi prakar k beej uplapdha hai Read More
Vet medicine
Lohiya Bazaar,Gwalior
We are stockist of vet medicine and any one poltry hgbjhbvcbhvbgbbvvvvvvvvvcccvbvvbbvvbc v cbvvvvcvvvvcvvvcdvvcvvccbvcvvcbcvcfbbvbbbbn cgbcdgvvvbbbfbbhgbbbbggff Read More
Persian cat
Shrinathpuram,Bareilly
Chicken
Sataran,Moradabad
Desi dual purpose chicks
Yadav Colony,Jabalpur
Pure desi day old chicks available contact 9993945467 Read More
Kadaknath birds 1 kg. To 1.2 kg.
Yadav Colony,Jabalpur
Pure Kadaknath male Bird's available only 350/- per kg. Read More
G Sea power
Sanjeevani Nagar,Jabalpur
Rooster poultry
Bhatauli,Jabalpur
Sugar cane chip and bud cutter
Vishwakarma Industrial Area,Jaipur
Sugar cane chip and bud cutter machine contact 8233482613 Read More
Wheat paddy cutter
Vishwakarma Industrial Area,Jaipur
Desi & देसी क्रॉस चूज़े उपलब्ध हे
Bhopal, Madhya Pradesh, India
Day old chicks rir . Dp. Dp cross
Broiler
Kuroiler
All poultry chicks Read More
Top quality german Shepard puppy
Bhopal, Madhya Pradesh, India
Top quality german Shepard puppy for sale Rollins dog Read More