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 (10333,10335,10338,10342,10344,10725,10728,10730,10733,10736,14658,14659,14661,14662,14664,14665,14668,14669,14843,14913,14948,15300,15303,15305,15308,15309,15314,15317,15323,15749,15752,15756,15757,15763,15766,15770,27382,16965,16966,16969,16976,18328,18329,18330,18331,18332,18333,19394,19402,19705,20931,20934,20936,20938,20940,21356,21358,22439,22459,22470,22480,22580,22586,22589,22591,22592,22595,22612,22613,22616,22618,22620,22778,22780,22783,22785,24887,24890,24971,24972,24973,25079,25178,25180,25182,25183,25212,25211,25214,25213,25215,25217,25218,25219,25220,25221,25222,25228,25227,25229,25230,25238,25239,25240,25241,25242,25243,25244,25246,25245,25247,25248,26231,26250,26245,26246,26248,26252,26254,26257,26255,26258,26259,26260,26330,26328,26331,26333,26349,26352,26350,26351,26353,26461,26463,26462,26464,26465,26484,26483,26485,26486,26487,26488,27389,27397,27398,27410,29095,29100,29327,29329,29343,29347,29346,29348,31635,31636,31637,31638,31763,31768,31770,31771,31775,31777,31782,31786,31788,31787,31789,31794,31796,31798,31799,31800,31803,31853,31858,31855,31856,31857,31859,31860,31861,31862,31863,31864,31923,31920,31919,31921,31922,31925,31926,31927,32019,32020,32021,32023,32024,32375,32376,33427,33429,33430,25216,34255,34264,34269,34270,34277,34278,34280,35004,35006,35008,35012,35013,35295,35296,35297,35298,35299,35300,35468,35467,35469,35470,35471,35472,35473,35474,35475,35476,35477,35478,35480,35565,35566,35567,35568,35569,35664,35665,35666,35667,35668,35669,36642,36641,36643,36644,36645,36646,36647,36654,36655,36940,36941,36942,36943,36945,37228,37229,37231,37232,37230,38115,38117,38118,38119,38120,38121,38123,38124,29352,29353,38240,29351,38324,38325,38326,38328,38327,38329,38330,38331,38332,38333,38334,38335,38336,38337,38362,38361,38363,38364,38365,38366,38367,38512,38634,38635,38636,38637,29350,39349,39411,39413,39414,40566,40574,40577,40570,40560,40580,40643,40556,40892,41699,41702,41703,41706,41708,41854,41859,41861,41862,41867,41870,41873,41874,41876,41877,41879,41881,42014,42027,42037,42041,42043,42044,42054,42046,42047,42061,42069,42074,42079,42077,42792,42793,42794,43262,43263,43264,43646,43647,43648,43637,43651,43652,43653,43655,43656,43667,43668,43680,43681,43683,43685,43686,43688,43689,43691,43710,43711,43760,43761,43770,43772,43887,43901,43903,43908,43914,43921,44705,44707,44708,44706,44709,45365,45399,45402,45372,45406,45793,47283,47438,47466,47469,47530,47531,47532,47533,49276,49279,49282,49285,49638,49637,49684,50097,50100,50111,50102,50098,50107,50112,50113,50119,50118,50125,50128,50131,50132,50137,50144,50148,50149,50152,50156,50294,50301,50303,50307,50308,50316,50315,50318,50321,50326,50328,50329,50330,50752,50760,50762,50767,51148,51150,51158,51163,51169,51173,51184,51187,51191,51193,51194)) OR (categoryID IN (748)) ) AND ( enabled=1) AND status_off <> 1