SELECT `aff_offers`.*, `affiliates`.`aff_type`, `affiliates`.`id` as `affiliates_id`, `office` as `area_name`, `affiliates`.`phone` as `whatsapp_no`, 0 AS `distance_km` FROM `aff_offers` JOIN `affiliates` ON `aff_offers`.`aff_id` = `affiliates`.`id` WHERE `aff_offers`.`status` = 1 AND `aff_offers`.`publish_status` = 1 AND `affiliates`.`aff_type` = 2 AND `aff_offers`.`from_date` <= '2026-03-16' AND `aff_offers`.`to_date` >= '2026-03-16' AND ( `aff_offers`.`offer_name` LIKE '%Audiolotus%' ESCAPE '!' OR `affiliates`.`firm_name` LIKE '%Audiolotus%' ESCAPE '!' ) ORDER BY `aff_offers`.`create_by` DESC, (CASE WHEN distance_km IS NULL OR distance_km = 0 THEN 1 ELSE 0 END) ASC, distance_km ASC LIMIT 12 I Am Automotive - Exciting Offers and Discounts

Connecting You to What Matters Nearby !

Speedweb Services LLP sponsored Divine Educational & Charitable Trust NGO Krishi Mithra FPO GOVARDHINI BGS FPO Karnataka Human Rights Committee Social Welfare
Join Now

📱 Best experienced and accessed on mobile devices.

📢 Join Now Buy & Sell Community on WhatsApp!