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 (725,1752,1755,1744,1426,1295,2679,2681,1746,2685,1750,1279,2687,2736,2735,1326,1748,1747,726,1753,1758,2684,1596,2682,1749,1751,1756,1290,1423,1759,1745,1757,1579,911,1571,1592,1318,2739,2737)) OR (categoryID IN (645)) ) AND ( enabled=1)