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.8466937)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.94616599999995)) + SIN(RADIANS(26.8466937)) * 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
Om agri junction
Salon Bazar,Rae Bareli
Hamare yanha sabhi prakar k beej uplapdha hai Read More
Kadaknath Chicken ,mo -6390090174
Mugishapur,Kanpur Dehat
Persian cat
Shrinathpuram,Bareilly
Vet medicine
Lohiya Bazaar,Gwalior
We are stockist of vet medicine and any one poltry hgbjhbvcbhvbgbbvvvvvvvvvcccvbvvbbvvbc v cbvvvvcvvvvcvvvcdvvcvvccbvcvvcbcvcfbbvbbbbn cgbcdgvvvbbbfbbhgbbbbggff Read More
Chicken
Sataran,Moradabad
Oyester mushroom
Nagahra,Patna
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
Shipra chicks
Muzaffarpur
Shipra chicks
Muzaffarpur
Shipra chicks
Muzaffarpur