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 (978,979,980,1560,1822,2463,2515,2975,3093,3100,3487,3539,3571,3817,3821,3826,5759,5778,5960,5962,5965,6984,7209,7210,7241,7815,8327,8363,11294,11297,11457,11459,11461,11493,11495,11770,11773,11789,11792,11795,11813,11819,11833,11862,11863,11927,12033,12037,12041,12049,12264,12310,12315,12885,14154,14187,14204,14206,14209,14217,14218,14219,14447,14454,14562,14616,14752,14842,14859,14874,14998,15019,15241,15246,15353,15410,16291,16878,17008,17009,17050,17052,17055,17066,17117,17859,17861,17862,17864,18125,18301,18302,18388,19642,19731,19752,19755,19758,19993,20056,21240,21293,21296,21558,21658,22127,22487,22796,22803,23033,23034,23465,23492,23493,23496,23497,23499,23721,23731,23732,23736,23737,23743,23748,23760,23879,24124,24233,24234,24390,24630,24643,24808,24809,26072,26300,26354,26577,26839,26931,26966,26973,26991,27005,27014,27291,27935,27990,27991,27997,28063,28098,28258,28570,29035,29056,29059,29162,29163,29193,29198,29214,29215,29216,29217,29218,29219,29220,29221,29222,29223,29328,29333,29344,29515,29516,29545,30235,30239,30335,30372,30376,30380,30384,30586,30637,30647,30670,30673,31385,32835,33143,33175,33557,33740,34474,34482,35261,35594,35607,35836,35900,35995,36362,36366,36407,36423,36429,36463,47596,47715,47719,47600,47604,39111,42765,43356,43425,43907,43911,43915,44944,45493,46663,47315,47341,47352,47359,47411,47414,47483,47501,47493,47515,47537,47759,47940,47946,47971,49154,49419,49421,49452,49460,49529,49530,49542,49547,49548,49650,49656,49702)) OR (categoryID IN (604)) ) AND ( enabled=1) AND status_off <> 1