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 (1296,1299,1302,2539,2545,2553,2858,2990,3051,3066,3116,3117,3181,3182,3183,3184,3190,3191,3192,3205,3206,3207,4121,4122,4123,4225,4244,4245,4598,4599,5049,5051,5386,5467,5471,5492,5493,5494,5495,5496,5497,5498,5499,5500,5602,5691,5794,5795,5796,5797,5798,5799,5800,5801,5802,5835,5836,5993,5995,5996,5997,6212,6241,6244,6245,6249,6250,6252,6253,6256,6310,6317,6318,6319,6775,6776,6777,6778,6784,6785,6794,6795,6796,6801,6802,6803,6931,6932,6933,6934,8380,8390,9632,9662,9664,10349,10803,10805,10806,10905,10906,10911,10916,10918,10921,10922,10923,10926,10931,10934,10936,10939,10940,10942,11088,11089,11469,11534,11896,12135,12136,12243,12455,12457,12655,12656,12657,12658,12659,12660,12814,14324,14422,14423,14426,14438,14890,14902,14906,14908,14909,14910,14977,14978,14979,14980,16081,16082,17272,19895,19908,19909,19912,21811,21817,21819,21826,21834,21836,23815,23816,23890,23891,41279,41280,27927,28182,28195,28196,28316,28320,28324,29410,29420,29460,29523,29524,29525,29526,29532,29533,29534,29535,29536,29569,29570,29572,29575,29574,29576,29586,29589,31064,31147,31148,31149,31161,31162,32652,32653,33209,33647,33886,34113,34114,35423,35424,35425,35426,35427,35428,35429,35430,35431,35432,35435,35496,35497,35506,37160,37299,41277,39276,39943,39975,41278,40992,40993,40997,40996,43064,43065,43068,43069,43089,43090,43097,43098,43107,43108,43109,43110,43142,43141,43140,43402,43403,43412,43483,43488,43614,43613,43728,43792,44559,44582,44956,44961,44962,45035,45971,46659,46660,46661,46809,46808,46814,48481,49160,49172,49178,49802,49928,50911,50912,50913,50914,50915,50916,50917,50918,50919,50920,50921,50922,50923)) OR (categoryID IN (595)) ) AND ( enabled=1) AND status_off <> 1