Server shutdown in progress
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE( ( (p.productID IN (1125184,1204839,1204840)) OR (p.categoryID IN (24242056)) ) AND ( enabled=1)) AND in_country_lv=1 AND p.productID NOT IN (SELECT productID FROM SC_category_product cp1, SC_categories c1 WHERE cp1.categoryID=c1.categoryID AND c1.disabled=1 AND cp1.productID=p.productID AND p.hidden_category_visable=0) AND p.productID NOT IN (SELECT productID FROM SC_category_product cp1 WHERE cp1.productID=p.productID AND cp1.categoryID IN (3671,6163,6955,12835,23980021,23980964,23984349,25453885,25986857,23980024,23980026,23980022,23980025,23980023,23987769,23987771,23987768,23987770))