Ошибка в SQL запросе:
SELECT DISTINCT pup.prop_id, pup.product_id, prop.*, pup.type_view, pup.name AS value
FROM `mg_product_user_property_data` as pup
LEFT JOIN `mg_property` as prop
ON pup.prop_id = prop.id
LEFT JOIN `mg_category_user_property` as cup
ON cup.property_id = prop.id WHERE pup.`product_id` IN (9426,9423,9421,9416,9412,9406,9401,9399,9397,9395,9389,9388,9385,9381,9378,9377,9375,9372,9371,9369,9368,9362,9361,9356) AND cup.category_id IN (15,5,50,6,5,4,5,5,5,7,9,19,11,5,9,9,9,7,19,7,9,5,5,7) ORDER BY `sort` DESC
Disk full (/tmp/#sql_413_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")/var/www/unico/data/www/femmeretail.kz/mg-core/models/catalog.php (line 1990)
/var/www/unico/data/www/femmeretail.kz/mg-core/models/catalog.php (line 236)
/var/www/unico/data/www/femmeretail.kz/mg-core/controllers/catalog.php (line 172)
/var/www/unico/data/www/femmeretail.kz/mg-core/lib/moguta.php (line 0)
/var/www/unico/data/www/femmeretail.kz/mg-core/mg-start.php (line 0)
/var/www/unico/data/www/femmeretail.kz/index.php (line 98)