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(17.385044)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.486671)) + SIN(RADIANS(17.385044)) * 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
Quality Onion
Bengaluru, Karnataka, India
Cotton seeds cake
APMC,Bijapur
Very good quality cotton seeds cake with more oil content call 9902381682 Read More
Kadaknath chicken available at hyderabad, telengana
Kachiguda,Ranga Reddy
Kadaknath chicken available at hyderabad telengana.
Big hen 3000 rs pair Read More
Natu kodi (Country Chicken)
Banjara Hills,Hyderabad
ShihTuz Puppies For Sale
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
Shih-Tuz
male and female puppies
available
contact +91+919052199325 Read More
#india #USA we supply puppies (( ShihTuz Puppies For Sale)) Cell : +918106677888WhatsApp :+918106677888
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
#india #USA we supply puppies
(( ShihTuz Puppies For Sale))
Cell : +918106677888
WhatsApp :+918106677888 Read More
#india #USA we supply puppies (( Malates Puppies For Sale))
7-1-32/15 Priya Residancy, Hyderabad, Telangana, India, 500016
#india #USA we supply puppies
(( Malates Puppies For Sale))
Cell : +918106677888
WhatsApp :+918106677888 Read More
Hunter irrigation systems
Upparpally,Hyderabad
We r dealer and distributors for hunter irrigation systems Read More
Mulch and Stretch film (Agricultural Films)
Toli Chowki,Hyderabad
We are the suppliers of Mulching Film Rolls n Stretch film.contact 9100932164 Read More
Mangos
Manikonda,Ranga Reddy
Badam, Rasalu, available daily 15 tonnes Read More
Pure çountry hen egg
Nizampet,Ranga Reddy
Each peice rs 12...,for bulk orders...plz cal Read More
Shihtuz female puppis for sale
Hyderabad, Telangana, India
Shihtuz and female puppies
Show
Quite
Deworming
Done
Top aunty
+91888676.1188 Read More