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 (18544,18549,18553,18554,27335,27350,29237,29239,29242,29252,29308,29309,29324,29323,29325,35550,35551,35552,35553,35554,41677,41678,41679,39426,39428,39430,39432,41680,41681,41683,41682,41684,41687,41685,41224,41225,41226,42046,42047,42061,42074,42077,42103,42123,42125,42126,42127,42128,42130,42131,42132,42133,42188,42190,42192,42195,42196,42197,42211,42212,42213,42214,42215,42216,42229,42230,42231,42232,42233,42234,44906,44920,44932,44933,44939,45077,45082,45158,45160,45161,45163,45165,45166,45797,45804,45818,45833,45834,45882,45884,49239,49242,49244,49248,49251,49270,50828,50829,50830,50833,50834,50836,50838,50840)) OR (categoryID IN (1065)) ) AND ( enabled=1) AND status_off <> 1