error ; Unknown column 'filter_' in 'where clause'

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 = WHERE business.county = 57 AND business.live_or_archived = 'l' AND ( filter_ = 'y') ORDER BY advert_tariff DESC, randomised_id LIMIT 0, 10