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(13.0826802)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.27071840000008)) + SIN(RADIANS(13.0826802)) * 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
Desi millet/ kambu/bajera for dale
Gerugambakkam,Kanchipuram
One tonn of pearl millet/ kambu /bajeera for sale @rs40 per kg @ Chennai. Read More
Organic Black Gram
Medavakkam,Kanchipuram
Organically Grown Black Gram (Ulundu) available for sale as Rs.110/kg. Total Quantity: 135 kgs. Minimum Order: 40kgs. Place: Medavakkam,Chennai. Interested Plea Read More
Mangoes baernisha
Vellore
Have 30 tons of baernisha for cutting average size 600 grams to 900 grams...farm fresh ready for cutting .. Read More
Sri Power Feed
Arani,Tiruvannamalai
Sri Power Feed increases the FAT and SNF percentage in milk so it gives more money to milk producer in low cost Read More
Watermelan
K K Nagar,Villupuram
Farm fresh Watermelan available daily 20 tons Read More
Guava farm fresh
K K Nagar,Villupuram
Fresh guava available daily 3ton
Whatsapp 9095975355 Read More
Nature's valley
Ambedkar Nagar,Nellore
All kinds of organic products in retail Read More
KSR Farms & Nursery
Chittoor
We supply Chrysanthemum plants (Chamanthi /Sevanthi)
Having 10 years of experience in supplying plants .having 20 varieties of plants with cost ranging from 1 R Read More