Table './azb74/SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE ( (p.productID IN (7797,7802,7803,7804,7805,7806,21372,21374,21376,21377,21378,21379,21384,21385,21386,21388,21389,21392,21393,21397,21717,21719,21725,21735,21792,21796,21798,21803,21806,21808,21810,21814,24197,24205,24206,24207,24225,24277,24278,24280,24291,24292,24293,25091,25093,32057,32059,32060,32063,32065,32064,32066,32067,32115,32116,32117,32118,32119,41876,41877,41879,41881,42851,42854,42858,42871,44107,44109,46338,46339,46340,46341,50100,50111,50118,50125,50131,50148,50310,50320,50324,50842,50844,50845,50849,50850)) OR (categoryID IN (1009)) ) AND ( enabled=1) AND status_off <> 1