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 = 47189 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 = 89 AND
					`is_active` = 1 AND
					cog.group_id = 408 AND
					po2v.value != '' AND
					po2v.value != 'undefined'
				 ORDER BY `catalog_category_option`.pos ASC, cov.pos ASC<br><br>MYSQL 1021: Disk full (/tmp/#sql_618_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br><br>