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 (722,725,725,726,726,911,921,922,1109,1112,1118,1119,1120,1122,1123,1124,1128,1279,1290,1290,1290,1295,1318,1318,1326,1423,1423,1426,1499,1536,1540,1541,1542,1571,1579,1580,1582,1592,1596,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1755,1756,1757,1758,1759,2679,2679,2680,2681,2681,2682,2682,2684,2684,2685,2685,2687,2687,2698,2701,2735,2736,2736,2737,2737,2737,2739,2739,2740)) OR (categoryID IN (562,563,565,566,641,578,644,645,556)) ) AND ( enabled=1)