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 = 8
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
Land for sale 1800000
Belakavadi,Chamarajanagar
2 acres
Red and black soil, both commercial and best for cultivation. From last 3 generation cultivation is in progress.
Location : From Bangalore 120kms far, Read More
Straburry land
3765, Bengaluru, Karnataka, India, 560078
Cotton seed oil cake
APMC,Bijapur
ರೈತ ಬಂಧುಗಳು ಜಾಧವ ಆಗ್ರೋ ಇಂಡಸ್ಟ್ರೀಸ್ ಕಡೆಯಿಂದ ನಮಸ್ಕಾರಗಳು
ನಿಮಗ Read More
Bharath ring tanks
Sultanpet,Coimbatore
Agriculture Land for Sale immediate
Magadi,Ramanagara
Immediate Agriculture land for Sale 2.5 acares with 80 coconut trees, 3 Borewell with running condition, (12000) chicke feeds 2 sheds urgent sale contact 96111 Read More
Rent Rabbit & Poultry Shed Available [ Natti Koli, Boiler & Layer (NO Integration)]
Goraghatta,Bangalore Rural
Rent Rabbit & Poultry Shed Available [ Natti Koli, Boiler & Layer (NO Integration)] Capacity: 5000 Birds, Rent: Rs 2/- Per Bird/Per Month, Advance: 1 Batch Rent Read More
All variety plants available here
Pottilanka,East Godavari
ಜೇನು ಸಾಕಾಣಿಕೆ (Organic Honey)
Indargi,Koppal
Agriculture land
Bhagyanagara,Koppal
ಒಟ್ಟು ನಾಲ್ಕು ಎಕರೆ ಇದೆ ಒಂದು ಎಕರೆಗೆ 6.50 ಲಕ್ಷ ಯಾರದಾರೂ ತೊಗಳ್ಳರು ಇ Read More
Facebook
Google
