Error SQL:


QUERY:
SELECT prop.id AS property, val.id AS value, val.text_name AS name FROM mlk_ru_properties AS prop INNER JOIN mlk_ru_properties AS val ON val.parent = prop.id LEFT JOIN mlk_ru_catalog_properties AS catalog_properties ON val.id = catalog_properties.text_name WHERE prop.check_active=1 and catalog_properties.parent IN ( SELECT catalog.id FROM mlk_ru_catalog AS catalog LEFT JOIN mlk_ru_catalog_cat AS catalog_cat ON catalog.id = catalog_cat.parent WHERE catalog.check_active = 1 AND catalog_cat.text_name IN (27136,27137,27139,27242,27259,27263,27271,27369,27530,27778,27918,28638,28692,28899,43370,43372,43374,43376,43378,43380,47201,47203) ) GROUP BY val.id ORDER BY prop.ord asc
MYSQL Error:Disk full (/var/tmp/#sql_9c4_0); waiting for someone to free some space...