Out of resources when opening file '/var/tmp/#sql_7c93_7.MAD' (Errcode: 24)<hr>SELECT p.*, IF(LENGTH(name_ua), name_ua, name_ru) AS _name_sort FROM (SELECT p.*, GROUP_CONCAT(CONCAT( p.productID,sp.variantID)) as model
FROM SC_products p 
LEFT JOIN SC_product_options_set sp ON (sp.productID = p.productID AND sp.optionID = 52)
group BY p.productID) p WHERE ( (p.productID IN (771,1259,2615,2613,1095)) OR (categoryID IN (576)) ) AND ( enabled=1)  ORDER BY ordering_available DESC, IF(in_stock&gt;0,1,0) DESC, sort_order, Price ASC, _name_sort LIMIT 0,21