MySQL error: Disk full (/tmp/#sql_12cab4_9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT `manufact`.*, `manufact_lang`.`title`, `manufact_lang`.`manufact_url`, GROUP_CONCAT(`shop`.`id` SEPARATOR ', ') AS `shops`, GROUP_CONCAT(`shop`.`name` SEPARATOR ', ') AS `shop_names` FROM `manufact` LEFT JOIN `manufact_lang` ON `manufact_lang`.`indexid`=`manufact`.`id` AND `manufact_lang`.`langid` = '1012' LEFT JOIN `shop_manufact` ON `shop_manufact`.`manufact_id` = `manufact`.`id` AND `shop_manufact`.`shopid` = '8' LEFT JOIN `shop_manufact` AS `sm2` ON `sm2`.`manufact_id` = `manufact`.`id` LEFT JOIN `shop` ON `shop`.`id` = `sm2`.`shopid` WHERE `manufact`.`accid` = '1' AND (`shop_manufact`.`shopid` = '8' OR `manufact`.`global` = 1) GROUP BY `manufact`.`id` ORDER BY `sort`