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.1702401)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.83106070000008)) + SIN(RADIANS(21.1702401)) * 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
JEEVAN BIO FORMULATION 500 ML
Udhna,Surat
It consists of natural growth promoters which improves the uptake and translocation of macro and micro nutrients.
It has rich Organic Zinc, Ferrous, Magnesium, Read More
Beavriya basina
Chitra,Bhavnagar
Wheat 496 certifide 40 kg bag at 1150 rs Read More
Black Grapes
Nashik, Maharashtra, India
We are leading exporters of the grapes.100 % organic Read More
Ripe Super
Nashik, Maharashtra, India
It is an ordinary product specialy design for all crops more details @ 8600135272 Read More
Onion King
Nashik, Maharashtra, India
It is an strong product specialy desing for Onion for more details call @ 8600135272 Read More
Agricultural blowers
MIDC Ambad,Nashik
Pesticide spraying machine for grape and pomegranate Read More
AL-NOOR 100
A BREED NAME OF PURE COUNTERY CHICKEN Read More
AL-NOOR 100
A NAME OF PURE COUNTRY CHICKEN
AVAILABLE
HATCHING EGGS
DAY OLD CHICKS
READY BIRD
PARENT BIRD
+919665759211
+919821156055
[email protected]
w Read More
Mobile
Ambawadi,Ahmedabad
Polish cap chicken
Titwala,Thane
6000 pair breeding pair 7 month chicken plez whatapp me 8286793686/9967909227 Read More
Rohad island red hen
Titwala,Thane
Pir pic 400 egg laying hen 7 month old days call on this number 8286793686/9967909227 from s.k.i poultry pets Read More
Deshi Chicks
Thane West,Thane
Pure Deshi chicks Rs 26 per number
Minimum quntity 500 number Read More
Gavaran Feed
Thane West,Thane
Good quality feed
Rs 25 per kgs
50 kgs bag
Door delivery Read More