MySQL error: Disk full (/tmp/#sql_19d53e_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT `product`.*,`product_lang`.*,`product_param`.*, `product_shop`.`price`, IF(`promo_percent`, (`promo_percent` / 100) * IF( `cp`.`price` != 0 , `cp`.`price`, `product_shop`.`price`) + IF(`cp`.`price`!=0,`cp`.`price`,`product_shop`.`price`), IF(`cp`.`price`!=0,`cp`.`price`,`product_shop`.`price`)) AS `discounted_price`, IF(`promo_id`, 1, 0) AS `has_promo`, NULLIF(`product_shop`.`price_old`, 0) AS `price_old`, `promo_type_id`, `promo_type_name`, `promo_type_title`, `promo_id`, `promo_name`, `promo_percent`, `promo_expires`, `cp`.`price` AS `c_price`, `cpo`.`price` AS `c_price_old`, `product_image`.`image`, `product_shared`.`images` AS `shared_images_id`, `product_shared`.`description` AS `shared_desc_id`, `product_shared`.`files` AS `shared_files_id`, `img_shared`.`image` as `shared_image`, `manufact`.`name` AS `manufact_name`, `manufact_lang`.`title` AS `manufact_title`, `measure`.`name` AS `measure_name`, `measure_lang`.`title` AS `measure_title`, COALESCE(`product_quantity`.`quantity`,0) AS `quantity`, (COALESCE(`product_quantity`.`quantity`,0)>0)+(`product`.`whenoutofstock`=1) AS `available`, `product_quantity`.`quantity` AS `available_quantity`, DATEDIFF(`product_quantity`.`next_restock_date`, NOW()) AS `days_until_restock`, `product_shop`.`category_id`, `product_shop`.`manufact_id`, `product_shop`.`rating`, GROUP_CONCAT(`product_category`.`categoryid` SEPARATOR ' ') AS `clist`, GROUP_CONCAT(DISTINCT `product_to_marker`.`product_marker_id` SEPARATOR ' ') AS `markers` FROM `product` LEFT JOIN `product_price` AS `cp` ON `cp`.`productid` = `product`.`id` AND `cp`.`type` = 1 AND `cp`.`shopid` = '2' AND `cp`.`currencyid` = '1200' LEFT JOIN `product_quantity` ON `product_quantity`.`productid` = `product`.`id` AND `product_quantity`.`shopid` = '2' LEFT JOIN `product_price` AS `cpo` ON `cpo`.`productid` = `product`.`id` AND `cpo`.`type` = 2 AND `cpo`.`shopid` = '2' AND `cpo`.`currencyid` = '1200' LEFT JOIN (SELECT `promo`.`id` AS `promo_id`, `promo`.`name` AS `promo_name`, DATE_FORMAT(`promo`.`dt`, '%d.%m.%Y') AS `promo_expires`, `product_promo`.`product_id`, `promo`.`promo_type_id` AS `promo_type_id`, `promo`.`percent` AS `promo_percent`, `promo_type`.`name` AS `promo_type_name`, `promo_type_lang`.`title` AS `promo_type_title` FROM `product_promo` LEFT JOIN `promo` ON `promo`.`id` = `product_promo`.`promo_id` AND DATE(NOW()) BETWEEN `promo`.`df` AND `promo`.`dt` LEFT JOIN `promo_type` ON `promo_type`.`id` = `promo`.`promo_type_id` LEFT JOIN `promo_type_lang` ON `promo_type_lang`.`indexid` = `promo_type`.`id` AND `promo_type_lang`.`accid` = '1' AND `promo_type_lang`.`langid` = '1007' WHERE `product_promo`.`shopid` = '2' AND `promo`.`id` IS NOT NULL ORDER BY `promo`.`percent` ) AS `promo` ON `promo`.`product_id` = `product`.`id` LEFT JOIN `product_related` ON `product_related`.`relatedid`=`product`.`id` LEFT JOIN `product_param` ON `product_param`.`productid`=`product`.`id` LEFT JOIN `product_lang` ON `product_lang`.`indexid`=`product`.`id` AND `product_lang`.`langid`='1007' LEFT JOIN `product_shop` ON `product_shop`.`productid`=`product`.`id` AND `product_shop`.`shopid` = '2' LEFT JOIN `product_category` ON `product_category`.`productid`=`product`.`id` LEFT JOIN `product_image` ON `product_image`.`productid` = `product`.`id` AND `product_image`.`sort` = 0 LEFT JOIN `product_shared` ON `product_shared`.`product_id` = `product`.`id` LEFT JOIN `product_image` AS `img_shared` ON `img_shared`.`productid` = `product_shared`.`images` AND `img_shared`.`sort` = 0 LEFT JOIN `product_to_marker` ON `product_to_marker`.`product_id` = `product`.`id` LEFT JOIN `manufact` ON `manufact`.`id`=`product_shop`.`manufact_id` LEFT JOIN `manufact_lang` ON `manufact`.`id`=`manufact_lang`.`indexid` AND `manufact_lang`.`langid`='1007' LEFT JOIN `measure` ON `measure`.`id`=`product`.`measure_id` LEFT JOIN `measure_lang` ON `measure`.`id`=`measure_lang`.`indexid` AND `measure_lang`.`langid`='1007' WHERE `product`.`id` IN ('29332','29331','29333','29334','29335','29336','29337','29338','29339','29340','29341','29342','29343','29344','29345','29346','29347','29348','29349','29350','29351','29352','29994','29995','29996','29997','29998','30099','30100','30101','30102','30103','30104','30105') AND `product_shop`.`shopid`='2' GROUP BY `product`.`id` ORDER BY `product`.`id`='29332' DESC,`product`.`sort`,IF(`product_lang`.`title`, `product_lang`.`title`, `product`.`name`)