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 (6690,6692,6693,6696,6697,6698,6699,6700,6701,6702,6703,6704,6713,6714,6715,6716,6717,6718,6719,6720,6721,6723,6724,6725,19192,19194,19208,19271,19272,19276,19330,19331,21538,21539,21540,21541,21542,21543,22249,22251,22252,22256,22348,22359,23221,23222,23393,24815,24822,24823,32279,32280,47052,47051,47053,47054,11634,11637,11639,11641,19197,19198,19199,19201,19202,19205,19266,19268,19269,19270,19277,19278,19279,19280,19325,19327,19329,24814,24820,33457,40188,11632,11633,11638,11663,2092,2093,2095,2096,11629,11630,11631,11642,22282,22284,48110,48109,48111,48112,48117,48118,48119,48121,48122,48123,48124,48125,11643,19195,19206,19273,19275,19332,24816,25377,11627,11662,11664,11665,11666,11667,11668,11669,11670,11671,32282,32283,32284,32285,32286,48126,48127,48128)) OR (categoryID IN (764,765,899,903,904,905,1057,902)) ) AND ( enabled=1) AND status_off <> 1