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