error ; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 20

SELECT *, AS business_id, free_or_paid, business_name, address1, address2, address3, postcode, geo_long, geo_lat, description_short, advert_tariff, TO_DAYS(renewal_date) - TO_DAYS(NOW()) AS days_to_renewal, AS town_name, type.title AS bb_type FROM business LEFT JOIN towns ON = LEFT JOIN type ON business.type = )