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 (25178,25182,25183,25211,25212,25213,25214,25215,25248,29349,29350,29351,29352,29353,38977,34253,34265,34267,34272,34275,38978,38125,38126,38131,38132,38134,38136,38137,38974,38182,38195,38199,38201,38203,38204,38208,38210,38212,38215,38254,38257,38259,38260,38264,38266,38268,38269,38271,38272,38274,38275,38278,38279,38281,38282,38285,38286,38288,38289,38313,38317,38318,38495,38504,38506,38509,38521,38523,38525,38532,38543,38544,38578,38569,38574,38579,38580,38581,39068,39062,38975,39008,39009,39012,39013,39014,39015,39016,39018,39019,39020,39021,39022,39132,39140,39141,39143,39145,39146,39187,39191,39194,39193,39196,39199,39201,39202,39205,39206,39209,39211,39212,39329,39330,39331,39332,39334,39340,39376,39381,39384,39387,41914,41915,41917,42049,42056,42063,42070,42755,42756,42758,42759,42761,42762,42770,42771,42773,42774,42776,42777,42778,42779,42780,42781,42782,42783,42795,42799,42809,42815,42818,42825,42831,42837,42840,42847,42852,42857,42863,42870,42881,42882,42884,42885,42892,45577,47513,47518,47521,49551,49553,49555,49568,49569,49577,49579,49587,49588,49600,49608,49618,49619,49622,49629,49633,49635,49643,49644,49747,49748,49749,49750,49751,49752,49753,49754,49755,49756,49757,49773,49774,49775,49776,49777,49778,49779,49780,49781,49782,50098,50102,50112,50119,50132,50137,50149,50152,50156,50307,50328,50329,50330)) OR (categoryID IN (1064)) ) AND ( enabled=1) AND status_off <> 1