select, a.main_image_id, ai.template_id, a.reg_year, a.price, a.mileage, mk.make, md.model from c_ads a inner join c_makes mk on a.make_id = inner join c_models md on a.model_id = left join c_ad_images ai on a.main_image_id = where dealer_id = 283 and a.expires_at > now() AND a.deleted_at IS NULL AND a.paused_at IS NULL AND a.reservation_id IS NULL AND a.web_sale_id IS NULL and is_dealer_special = 1 Unknown column 'a.web_sale_id' in 'where clause'