SELECT `catalog_category_option`.`option_id`, `catalog_category_option`.`title`, `catalog_category_option`.`is_active`, `catalog_category_option`.`prefix`, `catalog_category_option`.`postfix`, `catalog_category_option`.`descr`, cot.code, po2v.value AS value_id, cov.value FROM `catalog_category_option` JOIN `catalog_category_option_type` AS cot USING (type_id) JOIN `catalog_product_option2value` AS po2v ON ( po2v.product_id = 335308 AND `catalog_category_option`.option_id = po2v.option_id ) JOIN `catalog_category_option_group` AS cog USING (group_id) LEFT JOIN `catalog_category_option_value` AS cov ON (po2v.value = cov.value_id) WHERE `catalog_category_option`.category_id = 59 AND `is_active` = 1 AND cog.group_id = 109 AND po2v.value != '' AND po2v.value != 'undefined' ORDER BY `catalog_category_option`.pos ASC, cov.pos ASC

MYSQL 1021: Disk full (/tmp/#sql_618_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")