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 (1493,870,996,997,998,999,31714,1552,10921,25999,27424,48131,28106,28271,28206,28207,28241,39136,39158,39176,39212,39235,48061,39295,39319,39348,39376,39402,39430,39459,39482,39520,39570,39613,39641,39697,39719,39746,39790,39819,39848,39877,39906,39933,39968,39997,40028,40061,40090,40127,40153,40183,40216,40241,40266,40289,40314,40339,40382,40410,40439,40484,40504,40531,40558,40587,40619,40648,40677,40706,40735,40764,40792,40823,40851,40878,40908,40939,40968,41000,42740,42986,43015,43042,43070,43099,43629,43738,44072,44116,44152,44192,44257,44654,44733,48270,48845,49376,49412,49682,52269,52316,52411,52582,52629,52704,52749,52793,52859,52923,53002,53047,53221,53310,53366,53421,58329,58913,59364,59884,59984,60063,60120,60281,60501,60574,60645,60876,61714,62561,62393,61941,62324,63077,66332,66552,66641,66856,67068,67892,68088,68424,68637,69410,69755,69837,69897,69963,70023,70081,70261,71355,71485,73078,73634,73931,76205,76321,825))  GROUP BY p.productID ORDER BY is_in_stock DESC,  p.sort_order, _name_sort LIMIT 90,30