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(12.9715987)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.59456269999998)) + SIN(RADIANS(12.9715987)) * 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
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
Tejash K j
Baichanalli,Kodagu
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
Cotton seeds cake
APMC,Bijapur
Very good quality cotton seeds cake with more oil content call 9902381682 Read More
Ooty Rose
Bangalore Urban
Hf cows for sale
Ashok Nagar,Bangalore Urban
Please contact for hf and jersey cows 9845661012 Read More
Maize corn Silage
Ashok Nagar,Bangalore Urban
Silage is fermented, high-moisture stored fodder which can be fed to cattle, sheep and other such ruminants (cud-chewing animals) or used as a biofuel feedstock Read More
Agri MarketLink
Ashok Nagar,Bangalore Urban
Agriculture trading group including fruits vegitabls and all types of agri based products ..we also connect producers to consumers directly Read More
Smart corn silage
Ashok Nagar,Bangalore Urban
Silage is the animal feed which can increase your cattle milk quality and quantity. We assure you that we can supply you through the year whatever quantity you Read More
Soyabean
Sampangi Rama Nagar,Bangalore Urban
Good soyabeen at Rd 40 per kg. We have nearly about 100 tons stock. If any one want to purchase please contact 9448475716 Read More
Pond lining krushi Honda
Kalasipalya,Bangalore Urban
Manufacture of pond lining Krushi Honda Read More