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.9124336)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(75.78727090000007)) + SIN(RADIANS(26.9124336)) * 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
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
Fish
Farmana Badshahpur,Rohtak
Fish size 2 inch plus rahu common carp grass carp. Read More
Vet medicine
Lohiya Bazaar,Gwalior
We are stockist of vet medicine and any one poltry hgbjhbvcbhvbgbbvvvvvvvvvcccvbvvbbvvbc v cbvvvvcvvvvcvvvcdvvcvvccbvcvvcbcvcfbbvbbbbn cgbcdgvvvbbbfbbhgbbbbggff Read More
CFC PLUS
Patiala Chowk,Jind
This products is very use full for all animal as cow. And buffalow or pig or goat. Or bull etc
This full aayurved ic product Read More
Subscriber my You tube channel AGRICULTURE GURUji....https://youtu.be/fdHxUs2jOlQ
Ekalkhori,Jodhpur
Dosto subscribe Kijiye aapke Apne channel agriculture Guruji ko aur kis se sambandhit video paane ke liye Read More
Multipurpose dryers and egg incubators
Sadulnagar,Jodhpur
Dryers for spices(jaadhi, elam, kurumulaku, karayampoo, coffee etc..)fruits,vegetables,meat, pickles,aggarbhathis,chemicals,medicines etc drying machine with 3 Read More
Chicken
Sataran,Moradabad
Persian cat
Shrinathpuram,Bareilly
Kadaknath Chicken ,mo -6390090174
Mugishapur,Kanpur Dehat
SHET and stim rich 100% organic products
Sector 61,Sahibzada Ajit Singh Nagar
SHET(soil health enhancement technology) which helps to improve the soil physical, chemical and biological properties and increase the fertility Rs-1000
Stim ri Read More
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