Failed: SELECT tl.id as id, tl.announce as lot_announce, lz, pcd, et, dia, tl.color as color, width, diametr, tp.id as producer_id, tm.id as model_id, tp.handle as producer_handle, tm.handle as model_handle, tp.name as producer_name, tm.name as model_name, tmc.image_small as image_small, tm.announce_html as announce, tm.technology as technology, MAX(town_id) as max_town_id, add_url FROM ash_wheels_lots as tl, ash_wheels_lots_towns as tlt, ash_wheels_models as tm, ash_producers as tp, ash_wheels_models_colors as tmc WHERE tl.model_id=tm.id AND tm.producer_id=tp.id AND tmc.model_id=tm.id AND tmc.color=tl.color AND (( (tl.color='MC' AND tp.name='Replica') OR (tl.color='Алмаз графит' AND tp.name='K&K') OR (tl.color='Алмаз графит' AND tp.name='Rapid') OR (tl.color='Алмаз сильвер' AND tp.name='K&K') OR (tl.color='Алмаз сильвер' AND tp.name='Rapid') OR (tl.color='B' AND tp.name='TG Racing') OR (tl.color='BFP' AND tp.name='Replica') OR (tl.color='BK FP' AND tp.name='Racing Wheels') OR (tl.color='BLK POL' AND tp.name='TG Racing') OR (tl.color='C66MC' AND tp.name='Forsage') OR (tl.color='CFMJCQR' AND tp.name='Forsage') OR (tl.color='FSF' AND tp.name='Replica') OR (tl.color='GM FP' AND tp.name='Racing Wheels') OR (tl.color='GM POL' AND tp.name='TG Racing') OR (tl.color='GM06MC' AND tp.name='Forsage') OR (tl.color='GM08MC' AND tp.name='Forsage') OR (tl.color='GMF' AND tp.name='Replica') OR (tl.color='GOLD POL' AND tp.name='TG Racing') OR (tl.color='MATT BLACK POL' AND tp.name='TG Racing') OR (tl.color='MBF' AND tp.name='Replica') OR (tl.color='SAND POL' AND tp.name='TG Racing') OR (tl.color='SFP' AND tp.name='Replica') OR (tl.color='SIL POL' AND tp.name='TG Racing') OR (tl.color='TJ100MC' AND tp.name='Forsage') OR (tl.color='WHITE POL' AND tp.name='TG Racing') OR (tl.color='Айс' AND tp.name='iFree') OR (tl.color='Алмаз' AND tp.name='K&K') OR (tl.color='Алмаз' AND tp.name='Виком') OR (tl.color='Алмаз' AND tp.name='Скад') OR (tl.color='Алмаз белый' AND tp.name='Скад') OR (tl.color='Алмаз блэк-аурум' AND tp.name='K&K') OR (tl.color='Алмаз блэк-аурум' AND tp.name='Rapid') OR (tl.color='Алмаз матовый' AND tp.name='Скад') OR (tl.color='Алмаз платина' AND tp.name='Скад') OR (tl.color='Алмаз супер' AND tp.name='Скад') OR (tl.color='Алмаз черный' AND tp.name='K&K') OR (tl.color='Алмаз черный' AND tp.name='Rapid') OR (tl.color='Антрацит алмаз' AND tp.name='Скад') OR (tl.color='Венге' AND tp.name='K&K') OR (tl.color='DB CW P' AND tp.name='Racing Wheels') OR (tl.color='HS CW DP' AND tp.name='Racing Wheels') OR (tl.color='WF' AND tp.name='Replica') OR (tl.color='Венге' AND tp.name='Rapid') OR (tl.color='Блэк джек' AND tp.name='iFree') OR (tl.color='Алмаз матовый антрацит' AND tp.name='AEZ') OR (tl.color='Алмаз матовый графит' AND tp.name='DOTZ') OR (tl.color='Алмаз черный' AND tp.name='AEZ') OR (tl.color='Алмаз черный' AND tp.name='DEZENT') OR (tl.color='Алмаз черный' AND tp.name='DOTZ') OR (tl.color='Алмаз черный' AND tp.name='ENZO') OR (tl.color='Алмаз мэт' AND tp.name='K&K') OR (tl.color='Алмаз мэт' AND tp.name='Rapid') OR (tl.color='Алмаз матовый' AND tp.name='AEZ') OR (tl.color='Алмаз брасс' AND tp.name='K&K') OR (tl.color='Алмаз вайт' AND tp.name='K&K') OR (tl.color='Алмаз вайт' AND tp.name='Rapid') OR (tl.color='Алмаз брасс' AND tp.name='Rapid') OR (tl.color='Алмаз аргентум' AND tp.name='K&K') OR (tl.color='BKF' AND tp.name='Replica') OR (tl.color='BKF' AND tp.name='ALCASTA') OR (tl.color='GMF' AND tp.name='ALCASTA') OR (tl.color='BZF' AND tp.name='Replica') OR (tl.color='GF' AND tp.name='Replica') OR (tl.color='diamant-schwarz pol' AND tp.name='ALUTEC') OR (tl.color='diamantata' AND tp.name='OZ') OR (tl.color='graphite mirror face' AND tp.name='MAK') OR (tl.color='gun metall mirror face' AND tp.name='MAK') OR (tl.color='graphit-matt pol' AND tp.name='ALUTEC') OR (tl.color='schwarz-pol.matt' AND tp.name='BORBET') OR (tl.color='mistr.ant.pol.matt' AND tp.name='BORBET') OR (tl.color='schwarz-poliert matt MF' AND tp.name='BORBET') OR (tl.color='GMFP' AND tp.name='Replica') OR (tl.color='MBFP' AND tp.name='Replica') OR (tl.color='Алмаз белый' AND tp.name='Dotz') OR (tl.color='полировка шариками' AND tp.name='Dotz') OR (tl.color='Алмаз аргентум' AND tp.name='Rapid') OR (tl.color='Алмаз платинум' AND tp.name='K&K') OR (tl.color='Алмаз матовый' AND tp.name='OZ') OR (tl.color='Алмаз черный' AND tp.name='Alutec') OR (tl.color='Алмаз грей' AND tp.name='Скад') OR (tl.color='Алмаз платинум' AND tp.name='Rapid') OR (tl.color='bd' AND tp.name='ТЕЧ-ЛАЙН') OR (tl.color='sd' AND tp.name='ТЕЧ-ЛАЙН') OR (tl.color='bd' AND tp.name='Tech Line') OR (tl.color='sd' AND tp.name='Tech Line') OR (tl.color='Алмаз черный' AND tp.name='Скад') OR (tl.color='Алмаз грей матовый' AND tp.name='Скад') OR (tl.color='mbfl' AND tp.name='Replica') OR (tl.color='wf' AND tp.name='YOKATTA') OR (tl.color='bkf' AND tp.name='YST') OR (tl.color='mbf' AND tp.name='YST') OR (tl.color='mbmf' AND tp.name='YST') OR (tl.color='sf' AND tp.name='YST') OR (tl.color='ms' AND tp.name='Replica') OR (tl.color='machined grey' AND tp.name='Replica') OR (tl.color='mbf' AND tp.name='YOKATTA') OR (tl.color='wf' AND tp.name='Alcasta') OR (tl.color='mgr' AND tp.name='Replica') OR (tl.color='machined white' AND tp.name='FM') OR (tl.color='mb' AND tp.name='FM') OR (tl.color='ms' AND tp.name='FM') OR (tl.color='sfp' AND tp.name='Shark') OR (tl.color='Алмаз черный' AND tp.name='Replica') OR (tl.color='Алмаз грей' AND tp.name='Replica') OR 0 )) AND ((tlt.town_id = 12 AND tlt.is_enabled > 0) OR (tlt.town_id = 1 AND tlt.is_enabled >= 4)) AND tl.id = tlt.lot_id AND tp._invisible = 0 GROUP BY id ORDER BY MAX(town_id) DESC
MySQL error (1021): Disk full (/tmp/#sql_c2d_0); waiting for someone to free some space...