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 = 5
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
MR.Farmer
Bus Stand Road, Channapatna Housing Board Colony, Hassan, Karnataka, India
Ooty Rose
Bangalore Urban
ಸಾಂಬಾರ್ ಈರುಳ್ಳಿ
Karnataka, India
ನೈಸರ್ಗಿಕ ಕೃಷಿ ಪದ್ಧತಿ ಅಳವಡಿಸಿಕೊಂಡು ಬೆಳೆದ ಸಾಂಬಾರ್ ಈರುಳ್ಳಿ Read More
Ragi for sale
T. Dasarahalli,
Ragi (red) for sale at kunigal. Qunitol rs 2500 Read More
Kashi Tomato
Jyothigowdanapura,Chamarajanagar
Big juicy native tomato seed strongly recommended for home gardeners Read More
पोल्ट्री खत(Two wheeler)
Vaijapur,Aurangabad
cotton seed oil cake
APMC,Bijapur
we are the manufacturer and wholesale tarder of cotton seed cake,
Godrej bypro
godrej milk more
godrej Smr
toogari chinni
makka chinni
Goodi boosa
and all Read More
pepper plants.
Jayapura,Shimoga
Based on weight of bags we supply pp bags and liners also. Read More
Aries all range
Kailash Nagar,Rajnandgaon
Pepper plants
Kalmane,Shimoga
Pepper plants is available at Agaradahalli camp Read More
Pepper plants is ready to sale
Paniyu plants are available at Agaradahalli camp
Bhadravathi (to)
Shimoga Read More
Ragi for sale
Kunigal,Tumkur
10 quintols of fresh ragi for sale from farmer from kunigal. Contact 7892875962 Read More
Rabbit dung and manure
Doddanekkundi,Bangalore Urban
Rabbit fertiliser is rice and phosphorus, nutritents that plants for healthy growth Read More
Facebook
Google
