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 = 408 and a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.reservation_id is null AND a.web_sale_id IS NULL and is_dealer_special = 1 The last transaction was aborted due to Seamless Scaling. Please retry.