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 (6129,6130,6131,6888,6889,6890,6891,6894,6895,6896,6897,6898,6899,6900,6901,6902,6920,9464,9465,9466,9469,9501,9502,9508,11010,11011,11069,11070,11159,11160,11162,11163,11850,11854,11856,11860,12008,12015,12016,12017,12018,12207,12208,12210,12211,12213,12214,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12776,12915,12916,12954,12955,12956,12960,12961,12962,12963,12964,12965,12966,12967,12968,12969,12970,12971,12972,12973,12974,12975,12976,12977,12978,12979,12980,12981,12982,12983,12984,12985,12986,12987,12988,12989,12990,12991,12992,12995,12996,13000,13001,13159,13160,15097,15103,15107,17779,18035,18036,18046,18048,18052,18053,18055,18061,18062,18065,18066,18071,18072,18138,18140,18578,18581,18582,19431,19434,19437,19439,19441,19444,19447,19450,20373,20374,20376,20377,20378,20467,20469,20471,20472,20473,20492,20493,20494,20495,20497,20498,20499,20501,20502,20503,20505,20506,20507,20508,20509,20511,20512,20513,20518,20521,20522,20523,20572,20573,20574,20578,20953,20954,20955,20958,20959,20961,20962,20963,20971,21015,21016,21104,21105,21106,21107,21108,21109,21110,21111,21218,21219,21221,21222,21254,21255,21256,21257,21261,21263,21327,21328,21336,21338,21417,21420,21425,21428,21434,21437,21442,21503,21504,21505,21506,21514,21516,21517,21520,21521,21599,21604,21607,21608,21615,21616,21617,21625,21626,21627,21628,21630,21631,21632,21637,21638,21639,21641,21643,21644,21648,21649,21652,21653,21657,21659,21662,21663,21668,21669,21672,21673,21674,21687,21688,21689,21692,21693,21694,21697,21698,21702,21703,21704,21707,21708,21711,21712,21713,21745,21749,21750,21751,21752,21753,21754,21755,21756,21757,22141,22142,22143,22144,22249,22251,22252,22256,22555,22556,22557,22916,22918,22919,22920,28428,28426,23195,23196,23197,23207,23208,23209,23216,23217,23218,23219,23224,23226,23227,23229,23230,23441,25394,25623,25624,25625,25626,25629,25723,25724,25760,25763,26801,26802,26803,28437,28439,28441,28447,28450,28451,28452,28460,28463,28461,28462,28470,28488,28489,28492,28490,28493,28494,28496,28497,28498,28502,28500,28501,30100,30101,30104,30109,30112,30113,30118,30119,30124,30125,30133,30140,30149,30156,30157,30158,30159,30196,30205,30218,30232,30236,30240,30244,30249,30263,30278,30282,30287,30288,30312,30319,30322,30325,30369,30373,30377,30381,30385,30388,30391,30395,30401,30403,30406,30423,30437,30444,30450,30513,30596,30630,30638,30642,30645,30648,30653,30658,30663,30668,30671,30674,30679,30677,30681,30686,30692,30699,30702,30725,30737,30769,30771,30774,30808,30809,30817,30835,30851,30863,30875,30880,30884,30887,30891,30895,30900,30905,30909,30912,30915,30918,30921,30954,30959,30968,30993,30994,31000,31004,31005,31007,31008,31010,31011,31013,31014,31016,31019,31028,31025,31022,31031,31034,31039,31040,31041,31047,31048,31213,31214,31545,31546,32262,32263,32264,33089,33928,33929,33931,33932,34018,34019,34040,34089,34090,34204,34205,34206,34207,41402,40943,40944,40945,40949,40950,41403,41347,41404,41405,41406,41407,41408,41409,41410,41411,41412,41413,41414,41415,41571,41574,41585,41586,41587,41588,41589,41590,41592,41593,41594,41595,41596,41719,41720,41721,42372,42376,42380,42412,43741,45765,45777,46378,46684,46691,47052,47051,47053,47054,47214,47215,47222,47224,47456,47457,47459,47460,50332,50334,50907,50908,51202,51203)) OR (categoryID IN (656)) ) AND ( enabled=1) AND status_off <> 1