Failed: SELECT DISTINCT sp.*, subsp.sale_value AS sub_sale_value, subsp.start_col AS sub_start_col FROM ash_sp as sp INNER JOIN ash_sp_towns as spt ON spt.sp_id = sp.id INNER JOIN ash_tyres_lots_have_sp as tlhs ON tlhs.sp_id = sp.id INNER JOIN ash_tyres_lots_towns as tlt ON tlt.lot_id = tlhs.lot_id LEFT JOIN ash_sp_tyres as subsp ON subsp.id = tlhs.sub_sp_id WHERE sp._invisible = 0 AND spt.is_enabled > 0 AND spt.town_id = 8 AND (tlt.town_id=8 OR tlt.town_id=1) AND (sp.is_limits_only=0 OR (tlt.is_enabled > 0 AND tlt.is_enabled < 4 AND tlt.town_id=8)) AND (sp.is_not_limits_only=0 OR (tlt.is_enabled >= 4 AND tlt.town_id=8)) AND tlhs.lot_id=8213 ORDER BY _order DESC, sp.id ASC
MySQL error (1021): Disk full (/tmp/#sql_c2d_0); waiting for someone to free some space...