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 (1603,3792,3793,3795,3796,3891,3892,3893,3894,3895,3914,3915,3916,3917,3990,3991,3992,3993,3995,3996,4002,4006,4007,4056,4057,4105,4106,4116,4117,4118,4119,4249,4250,4321,4325,4343,4344,4442,4556,4658,4661,4662,4665,4666,4681,4723,4724,5136,5222,5425,5426,5427,5691,5831,5832,5833,5994,5998,5999,6000,6794,6795,6796,6985,6986,6987,6988,6990,6991,6992,6993,11889,11896,11907,11910,11920,12090,12098,12109,12135,12136,12137,12138,12446,12454,12456,12544,12545,12546,12551,12552,12555,12560,12561,12568,12570,12571,12579,12591,12594,12891,12892,12893,12911,12912,12913,12918,12919,12921,12922,12923,12924,12928,12930,13274,13370,13374,13375,13430,13431,13434,13451,13459,13548,13555,13556,13589,14479,14481,14486,14493,14494,14606,14609,14612,15018,15076,15197,15211,15223,15225,15226,15227,15229,15380,15538,16285,16443,16444,16445,16455,16456,16506,16833,16834,16835,16836,16850,17111,17112,17204,17259,17272,17463,17465,17611,18515,18516,18575,18584,18585,18586,19676,19678,19869,19870,21304,21306,21406,21412,21413,21421,21422,21423,21424,21426,21427,21430,21431,21435,21436,21475,21476,22634,22804,22805,22806,22889,22890,22891,22892,22923,23118,23119,24051,24052,24056,24058,24063,26603,26605,26607,26874,26875,27360,27364,27367,27369,27371,27373,27375,28059,28064,28327,28330,29421,29423,29424,29427,29428,29448,29450,29458,29569,29570,29587,29590,29600,29608,30600,30603,30612,30613,30635,30726,30727,30746,30747,30764,30779,30789,30831,30839,31221,32245,32265,32266,32267,33252,33589,33593,33648,33774,33886,33949,34021,34706,34707,34709,34710,34893,34892,35281,35283,35423,35424,35425,35426,35427,35428,35429,35430,35431,35432,35438,35439,35440,35441,35442,35443,35444,35496,35497,35500,35501,35502,35503,35504,35505,37299,39087,39093,39092,39097,39099,39107,39108,39116,39119,39007,39023,39161,39165,39185,39186,39440,39443,39444,39452,39453,39461,39462,39464,39465,39470,39471,39472,39473,39474,39475,39476,39638,39843,39844,39845,39846,39847,39848,40727,40996,40997,43089,43090,43497,43504,43508,43509,43510,43516,43522,43523,43613,43614,43727,43731,44185,44186,44187,45387,46491,47749,47750,47751,47752,47762,48241,48242,48243,48245,48244,48427,48428,50895,50913,50914,50920,50921)) OR (categoryID IN (689)) ) AND ( enabled=1) AND status_off <> 1