Disk full (/var/tmp/#sql_1c58_0); waiting for someone to free some space...<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 (2681,2685,2679,2687,2684,2682,1540,1541,1542,2736,2739,1580,1582,921,1119,1120,1122,1123,1124,922,2680,2737,2740)) OR (categoryID IN (563)) ) AND ( enabled=1)