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(18.5204303)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.85674369999992)) + SIN(RADIANS(18.5204303)) * 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
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
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
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
Gavaran Feed
Thane West,Thane
Good quality feed
Rs 25 per kgs
50 kgs bag
Door delivery Read More
Deshi Chicks
Thane West,Thane
Pure Deshi chicks Rs 26 per number
Minimum quntity 500 number Read More
pure gir cow
9 month pregnent
milk capesity 15 lit / day Read More
kankrej cow
Talbid,Satara
pure A2 milk cow
pure kankej desi breed Read More
Hygienic Poultry Feed
Kada,Beed
1150/Bag Broiler Finisher
1200/bag Broiler starter
1300/Bag Broiler Pre starter Read More