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(21.1458004)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(79.08815460000005)) + SIN(RADIANS(21.1458004)) * 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
Tractor seats for john deere
Nagpur
Incubator
Ganeshpeth Colony,Nagpur
1 year old original condition desi chicken eggs 120 capacity and 80% hatchery please interested person contact me Read More
Accessorial Poultry and Fishery equipment marketing and sales
Dhantoli,Nagpur
We present ourselves as ASAN Marketing Solutions having expertise in machinery and equipment marketing and sales in food industry (poultry and and fishery mainl Read More
Jay incubators
Manewada,Nagpur
We r manufacturer of poultry incubators in nagpur, for querru cal me on my no 7709778021/8668617005 Read More
Multipurpose dryers and egg incubators
Lopa,Seoni
Dryers for spices(jaadhi, elam, kurumulaku, karayampoo, coffee etc..)fruits,vegetables,meat, pickles,aggarbhathis,chemicals,medicines etc drying machine with 3 Read More
Aries all range
Kailash Nagar,Rajnandgaon
HF Jersey Sahiwal Cows
Durg,Durg
High milk yielding HF Jersey Sahiwal Cows available for sale Read More
Rooster poultry
Bhatauli,Jabalpur
G Sea power
Sanjeevani Nagar,Jabalpur
Kadaknath birds 1 kg. To 1.2 kg.
Yadav Colony,Jabalpur
Pure Kadaknath male Bird's available only 350/- per kg. Read More
Desi dual purpose chicks
Yadav Colony,Jabalpur
Pure desi day old chicks available contact 9993945467 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