MySQL error: Disk full (/tmp/#sql_abb53_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT `category`.*,`category_lang`.*, GROUP_CONCAT(`shop`.`id` SEPARATOR ', ') AS `shops`, GROUP_CONCAT(`shop`.`name` SEPARATOR ', ') AS `shop_names` FROM `category` LEFT JOIN `category_lang` ON `category_lang`.`indexid`=`category`.`id` AND `category_lang`.`langid`='1010' LEFT JOIN `shop_category` ON `shop_category`.`category_id` = `category`.`id` AND `shop_category`.`shopid` = '5' LEFT JOIN `shop_category` AS `sc2` ON `sc2`.`category_id` = `category`.`id` LEFT JOIN `shop` ON `shop`.`id` = `sc2`.`shopid` WHERE `category`.`accid` = '1' AND (`shop_category`.`shopid` = '5' OR `category`.`global` = 1) AND `category`.`active` = 1 GROUP BY `category`.`id` ORDER BY `sort`