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(19.0759837)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.87765590000004)) + SIN(RADIANS(19.0759837)) * 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
Cotton seeds cake
APMC,Bijapur
Very good quality cotton seeds cake with more oil content call 9902381682 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
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
Lactifence Post Dip
Pashan,Pune
Use DeLaval Lactifence Post Dip n protect your cow from Mastitis.. Contact 02067218200 Read More
DeLaval Milking Machine
Pashan,Pune
World No 1 milking machine.. Now everywhere in india.
Use ISO standard DeLaval Milking machine for better udder health and longevity of cow.
Please contact 0206 Read More
DeLaval Dairy Farming Solutions
Pashan,Pune
DeLaval is a leading supplier and knowledge partner in dairy farming industry. We have farming solutions for 10 cows to 10000 cows. Read More
Agricultural blowers
MIDC Ambad,Nashik
Pesticide spraying machine for grape and pomegranate 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
Hi-Pro Calf Milk Replacer
Rahata,Ahmednagar
HI-PRO HEIFER Milk Replacer
Whey Protein Based Calf Milk Replacer (C.M.R) Very beneficial to calves under 3 months
Advantages of Hipro C.M.R
Calf rearing wi Read More
Chaitanya Gawran Cross chicks
Ahmednagar
Duration 75 days, 1.2 GRM's body weight, FCR 2.7 GRM's, mortality standard 2% , New generation desi cross breed bred by Chaitanya poultry feeds & Hatcheries ,G- Read More