Failed: SELECT IF( tm.season, tm.season, 3 ) AS season_summer, tl.id as id, load_index, speed_index, width, height, diametr, inches, c_post, diametr_full, add_url, tp.id as producer_id, tm.id as model_id, tl.articul as articul, tp.handle as producer_handle, tm.handle as model_handle, tp.name as producer_name, tm.name as model_name, tm.spikes as spikes, tm.image_small as image_small, tm.announce_html as announce, tm.season as season, MAX(town_id) as max_town_id FROM ash_tyres_lots_towns as tlt INNER JOIN ash_tyres_lots as tl ON tl.id=tlt.lot_id INNER JOIN ash_tyres_models as tm ON tm.id=tl.model_id INNER JOIN ash_producers as tp ON tp.id=tm.producer_id WHERE tl.model_id=tm.id AND tm.producer_id=tp.id AND tl.id=tlt.lot_id AND ((tlt.town_id = 6 AND tlt.is_enabled > 0) OR (tlt.town_id = 1 AND tlt.is_enabled >= 4)) AND (((tl.height='85'))) GROUP BY id ORDER BY MAX(town_id) DESC, season_summer ASC
MySQL error (1021): Disk full (/tmp/#sql_c2d_0); waiting for someone to free some space...