Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")<hr>SELECT SQL_CALC_FOUND_ROWS  p.*, p.name_ru AS _name_sort FROM SC_products p  JOIN SC_ZOB__category_product AS catprodt ON p.productID=catprodt.productID LEFT JOIN (SELECT `product_code`, 1 as `is_in_stock` FROM SC_ostatki JOIN `SC_sklad` ON `sklad`=`id` WHERE `enabled`='1'  AND (sklad IN (24, 13) OR send_store_id IN (24, 13)) GROUP BY `product_code`) as sort_rest_products ON p.product_code=sort_rest_products.product_code  WHERE (p.productID NOT IN (SELECT options_product FROM `SC_product_options_set` WHERE options_product &gt; 0 AND productID != options_product) AND p.enabled=1 AND catprodt.categoryID IN (67068))  GROUP BY p.productID ORDER BY is_in_stock DESC,  p.sort_order, _name_sort LIMIT 0,30