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 ,0 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'
AND tmi.category_id = 2
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
Water melon ( icebox)
Muthumariyamman Kovil,Mysuru
Seygenta suger Queen water melon crop ready to harvest... 30to 40ton available in Mysore distinct hunsur taluk Read More
lotus flower
Magadi Road, Govindaraja Nagar Ward, Agrahara Dasarahalli, Rajajinagar, Bangalore, Karnataka, India
potato
Magadi Road, Govindaraja Nagar Ward, Agrahara Dasarahalli, Rajajinagar, Bangalore, Karnataka, India
ad test
Magadi Road, Govindaraja Nagar Ward, Agrahara Dasarahalli, Rajajinagar, Bangalore, Karnataka, India
wheat
Malleshwara Underpass, Malleshwara, Bangalore, Karnataka, India
Ragi hullu (ragi dry gross)
around 5 tractors of ragi hullu or Millet grass is available for sale Read More
Gvt Custard Apple
Koppal, Karnataka, India
Custard Apple available in Gangavati Read More
ಕೊಪ್ಪಳದ ಜವಾರಿ ಮೊಸಂಬಿ
Koppal, Karnataka, India
ಕೊಪ್ಪಳದ ಜವಾರಿ ಮೊಸಂಬಿಗಾಗಿ ನಮ್ಮನ್ನು ಸಂಪರ್ಕಿಸಿ Read More
Munirbad Guava
Koppal, Karnataka, India
Reddish Guava available in Munirbad any body want chat with me ...giving all details of former Read More
Kinnal apple
Koppal, Karnataka, India
Kinnal apple for good health n worth for above price....anybody want chat with me ....I will give all details friends Read More
ಈರುಳ್ಳಿ
Koppal, Karnataka, India
ಗಿಣಿಗೇರಾ ಜವಾರಿ ಟೊಮ್ಯಾಟೊ
Koppal, Karnataka, India
30 ರೂಗೆ ಜವಾರಿ ಟೊಮ್ಯಾಟೊ ಗಿಣಿಗೇರಾದಲ್ಲಿ ಸಿಗುತ್ತೆ ಬೇಕಾದವರು ನನಗೆ Read More