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 (7468,7491,7833,7834,7835,7836,7840,7842,7845,7516,7519,7520,7521,7522,7523,7527,7528,7531,7533,7534,7537,7544,7546,7549,7553,7556,7562,7563,7570,7574,7575,7576,7577,7578,7579,7582,7584,7585,7588,7589,7602,7610,7614,7615,7619,7622,7627,7629,7632,7633,7634,7635,7637,7642,7643,7644,7645,7649,7650,7651,7652,7653,7654,7655,7656,7659,7661,7663,7664,7665,7673,7677,7682,7683,7684,7685,7686,7687,7688,7689,7692,7695,7696,7697,7698,7699,7700,7704,7706,7709,7710,7711,7712,7713,7817,7818,7819,7820,7823,7824,7825,7826,7827,7828,7829,7830,7831,7837,7838,7842,8017,8031,8032,8033,8035,8037,8038,8042,8043,8063,8068,8069,8070,8076,8079,8116,8117,9529,19765,19766,19767,19772,19774,19775,19776,19778,19779,19781,19782,19783,19784,19786,19787,19789,19790,19794,19796,19797,19798,19802,19808,19810,19813,19815,19816,19817,19818,19819,19820,19823,19824,19833,19838,19847,19848,19849,19851,19854,19856,19859,19860,19872,19875,19881,19882,19884,19889,19890,19892,19893,19894,19904,19905,20028,20041,20043,20054,20057,20065,20066,20122,20132,20136,20137,20138,20145,20153,20162,20163,20164,20169,20170,20173,20174,20176,20178,20184,20190,20193,20194,20197,20201,20202,21955,21973,21974,21982,21997,22001,22002,22003,22006,22010,22012,22013,22018,22019,22021,22026,22027,22029,22030,22032,22033,22037,22039,22043,22044,22166,22168,22173,22174,22176,22178,22193,22195,22207,22210,22218,22224,22226,22233,22235,22236,22238,22243,22244,22248,22257,22258,22259,22260,22265,22269,22271,22272,22273,22274,22278,22279,22281,22283,22285,22287,22288,22289,22293,22300,22306,22312,22313,22320,22322,22325,22326,22335,22336,22342,22346,22351,22353,22357,22367,22369,22371,22381,22385,22394,22400,22415,22416,26868,26870,7331,7334,7335,7338,7340,7341,7342,7403,7665,7716,7731,7832,7835,7836,7838,7843,7844,8080,21972,21980,22309,7337,7354,7355,7362,22264,22430,22431,22433,22436,22442,22444,22447,22452,22456,22468,22475,22476,22496,22521,8157,8220,8672,8673,8682,8683,8684,20181,20182,20183,22458,22499,22503,22506,22507,22511,22515,7331,7334,7335,7339,7340,7348,7368,7394,7395,7730,7731,7735,7835,7836,7839,7840,8097,8098,8099,8107,8109,8114,8115,8118,8120,8121,8122,8127,9531,9678,9681,9774,19816,22375,7843,8103,8107,8108,8140,8717,8718,8721,8722,8850,8884,9526,9679,9680,9681,20207,20210,20212,21963,22210,7307,7343,7361,7404,21962,21964,21965,21966,22254,22305,22349,22366,22395,22409,22411,22437,22499,22523,7639,7675,7690,7691,8699,21962,21964,22250,22406,9814,10003,10004,10006,7638,7830,7845,8877,19795,19802,7468,7470,7471,7472,7473,7474,7475,7477,7478,7479,7480,7481,7482,7483,7484,7486,7487,7488,7490,7491,7493,7494,7495,7496,7497,7498,7499,7500,7501,7502,7503,7830,7845,8877,8931,8932,8934,8935,8936,8937,8938,8940,8941,8942,8943,8944,8945,8946,8947,8948,8949,8950,8951,8952,8953,8954,8955,8958,8959,8960,8961,8962,8963,8964,8965,8966,8967,8968,8969,8970,8971,8972,8973,8974,8975,8976,8977,8978,8979,8980,8981,8982,8983,8985,8988,8989,8990,8991,8992,8993,8994,8995,8996,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9012,9013,9014,9015,9018,9019,9020,9021,9022,9023,9024,9025,9027,9028,9029,9030,9031,9032,9033,9034,9035,9036,9037,9038,9039,9040,9042,9043,9044,9045,9047,9048,9049,9050,9051,9052,9053,9054,9055,9056,9057,9060,9062,9063,9064,9636,9638,9641,9643,9644,9645,9646,9647,9649,9650,9651,9652,9653,9654,9656,9657,9658,9659,9660,7494,8723,8724,8725,8726,8727,8728,8729,8732,8733,8734,8736,8737,8738,8739,9814,9833,10126,10278,10279)) OR (categoryID IN (773,774,775,776,777,778,779,780,781,782,783,784,1006,785,786,772)) ) AND ( enabled=1) AND status_off <> 1