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 (774,1141,1145,1146,1175,1176,1191,1317,1331,1357,1358,2146,2369,2373,2593,2594,2668,2675,2682,2691,2715,2724,2844,2845,2846,2937,3228,3232,3236,3244,3245,3246,3288,3301,3302,3303,3304,3319,3320,3330,3334,3335,3359,3360,3361,3362,3371,3372,3375,3376,3382,3383,3399,3408,4026,4176,4259,4260,4704,4706,4731,5398,5411,5412,5413,5469,5537,5543,5989,6165,6166,6167,6168,6169,6170,6177,6180,6182,9470,9471,9472,9480,9482,10858,10859,10927,10944,11004,11073,11092,11093,11101,11102,11103,11104,11439,11440,11462,11464,11488,11500,11501,11502,11507,11517,11527,11528,11537,11552,11554,11556,11574,11575,11576,11577,11618,11641,11672,11674,11676,11693,11694,11709,11715,11718,11723,11729,11732,11738,11741,11744,11941,11942,11943,12217,12821,12822,12823,12824,12840,12841,12842,12855,12856,12863,12871,13172,13173,13174,13182,13195,13196,13214,13215,13224,13225,13242,13243,13247,13248,13249,13250,13480,13547,15109,15554,15869,15874,15877,15878,16147,16609,16618,16623,16646,16647,16654,16655,17223,17249,17282,17498,17899,17900,17901,17902,17903,18091,18092,18093,18116,18118,18673,18676,18682,18683,18684,18685,18687,18690,18692,18695,18696,18698,18699,18716,18719,18722,18724,18725,18730,18739,18740,18745,18751,18752,18782,18798,19386,19388,19480,19484,19493,19502,19503,19517,19518,19519,19557,19558,19652,19653,19925,20004,20005,20006,20007,20008,20009,20010,20011,20012,20040,20516,20594,20847,21009,21098,21167,21172,21187,21681,21682,21683,21722,21726,21728,21730,21737,21766,21769,21786,21807,21813,21858,21860,21889,21890,21891,21892,21893,21894,22132,22161,22540,22549,22553,22560,22571,22625,22718,22726,22888,22913,23059,23115,23190,23894,23895,23896,23897,23935,25254,25256,25258,25259,25266,25267,25295,25296,25380,25382,26881,27242,27244,27246,29654,29655,29665,29666,29765,29769,29771,29774,29777,29945,31265,32073,32458,32459,33119,33308,33312,33324,33327,34038,34051,34077,34189,34934,34935,34936,34937,34938,34941,34942,34951,34952,34954,34955,34956,35102,35111,35119,35131,35132,35141,35160,35161,35354,35357,35372,35373,35374,35381,35380,35382,35383,35384,35385,35386,35387,35388,35389,35390,35406,35410,35412,35415,35417,35421,36691,36692,37562,37563,37564,40299,40298,40906,40912,40930,41362,41332,41900,41901,41902,41910,41911,41912,41913,41966,42443,42676,42820,43037,43042,43371,43373,43377,43379,43381,43383,43387,43388,43389,43390,43837,43838,43839,43840,43841,43881,43882,44972,43024,45209,45659,45927,45932,45935,45939,45947,45948,45954,45953,45955,46100,46108,46139,46159,46170,46271,46287,46360,46368,46391,46526,46548,46631,46640,46674,46706,46776,46777,46786,46787,46937,46950,47046,47050,47049,47229,47231,47911,47912,47914,48020,48220,48221,48222,48252,48254,48255,48268,48372,48373,48374,48375,48376,48377,48378,48379,48502,48503,49057,49099,49102,49824,50418,50419,50587,50590,50597,50709,50909,50910,50925,50926,51047,51135,51141,51271)) OR (categoryID IN (618)) ) AND ( enabled=1) AND status_off <> 1