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 (1327,1585,1603,1609,1625,1632,1633,1647,1693,1698,1704,1710,1731,1954,1969,2080,2502,2506,2553,2555,3788,3789,3790,3791,3792,3793,3795,3796,3891,3892,3893,3894,3895,3914,3915,3916,3917,3990,3991,3992,3993,3995,3996,4002,4006,4007,4028,4045,4046,4320,4321,4442,4556,4593,4661,4666,4723,4724,5134,5222,5691,5696,5836,6931,6932,6933,6934,6985,6986,6987,6988,6990,6991,6992,6993,8346,8347,8384,8386,8391,8442,9424,9631,9633,9768,9855,9902,10782,10785,10802,10804,10898,10899,11348,11470,11896,11910,12004,12005,12120,12121,12560,12561,12568,12570,12571,12574,12579,12661,12662,12663,12859,12861,12911,12912,12913,13274,13370,13374,13375,13430,13431,13434,13459,13555,13556,13589,14404,14434,14435,14436,14437,14479,14481,14485,14486,14493,14494,14498,14502,14566,14568,14609,14612,14795,14797,14802,14807,14808,14888,15076,15211,15223,15227,15355,15376,15380,16285,16460,16461,16502,16850,16851,16895,16896,17266,17268,17270,17570,17571,17572,17573,17574,17611,17615,17617,17618,17621,17623,17625,18395,18398,19108,19109,19110,19111,21050,21248,22751,22752,22851,22852,22853,22854,22855,22856,22970,23011,23832,23845,24051,24052,24056,24058,24063,24086,26749,26750,26751,26752,26753,26754,26911,27252,27251,27918,27981,27980,28064,28135,29420,29421,29423,29427,29428,29450,29458,29460,29600,29620,29624,30436,30438,30474,30475,30600,30603,30612,30613,30635,30726,30727,30746,30747,30764,30779,30789,30831,30839,31154,31155,31156,31157,31170,31171,31221,31528,32245,32293,32652,32653,33166,33167,33568,33880,34021,34466,34900,34903,34905,34906,34907,35249,35439,35440,35500,35501,36070,37366,39486,39485,39487,39834,39835,39836,39837,39838,39844,39843,39845,39846,39847,39848,40241,40727,43097,43098,43101,43102,43103,43107,43108,43109,43110,43152,43404,43483,43497,43508,43509,47223,47225,48426,48510,48512,48513,48515,49769,49802)) OR (categoryID IN (599)) ) AND ( enabled=1) AND status_off <> 1