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 (122623) ) GROUP BY val.id ORDER BY prop.ord asc
MYSQL Error:Disk full (/var/tmp/#sql_9c4_1); waiting for someone to free some space...