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...