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.6868159)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(83.21848150000005)) + SIN(RADIANS(17.6868159)) * 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
Punganur breed for sales
Haripuram,East Godavari
Punganur breed avaliable in rajamundry interested one call me 8185088378 bull also available for crossing purpose and for sales Read More
Gir cow sale
Haripuram,East Godavari
Gir from Gujarat in ist calving 16 lts per day now in 2nd lactation 7 months pregnant crossed with gir bull Read More
Panchakalyani horse
Kapileswarapuram,East Godavari
All variety plants available here
Pottilanka,East Godavari
Sheep seller for meat purpose
Dosapadu,West Godavari
For sale
Kovvali,West Godavari
Jersi Hf cb
Mishrapada,Angul
Holstein cow
Thripuraram,Nalgonda
HF Jersey Sahiwal Cows
Durg,Durg
High milk yielding HF Jersey Sahiwal Cows available for sale Read More
Aries all range
Kailash Nagar,Rajnandgaon
Marigold flowers
Sircilla,Karimnagar
I have marigold flowers interested send me msg pls Read More