Out of resources when opening file '/var/tmp/#sql_7c93_0.MAD' (Errcode: 24)<hr>SELECT COUNT(DISTINCT p.productID) as cnt 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 (2532,2741,1448,2533,1517,1518,1691,2742)) OR (categoryID IN (581,582,584,585,633,630,603,607,614,642,558)) ) AND ( enabled=1)