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 (28027,28147,28149,28237,28239,28242,28244,28246,28251,28247,28250,28252,28253,28254,28260,28387,28390,28391,28392,28393,28437,28439,28454,28460,28461,28465,28470,28473,28471,28472,28476,28477,28480,28481,28484,28485,28488,28489,28492,28493,28496,28497,28500,28501,28966,28967,28969,28970,28972,28973,28975,28976,28978,28979,28981,28982,28984,28985,29039,29040,29042,29043,29045,29046,29048,29049,29051,29052,29067,29068,29070,29072,33196,33298,34719,34720,34721,34722,34723,35766,35777,35779,35782,35784,35855,35856,35858,35859,35865,35866,35868,35877,35899,35901,35902,35904,35908,35909,35993,35994,35996,35999,36002,36003,36005,36006,36021,36025,36034,36035,36043,36048,36049,36051,36052,36054,36055,36059,36060,36064,36065,36068,36067,36071,36075,36076,36078,36079,36081,36082,36084,36085,36087,36089,36090,36091,36092,36094,36175,36190,36189,36197,36198,36199,36200,36203,36206,36221,36224,36225,36227,36240,36234,36239,36238,36237,36242,36243,36245,36246,36255,36256,36264,36268,36270,36272,36273,36278,36279,36281,36282,36285,36286,36287,36289,36290,36292,36293,36295,36296,36304,36305,36306,36307,36308,36309,36311,36312,36314,36316,36317,36319,36320,36322,36323,36325,36326,36329,36330,36332,36334,36336,36337,36339,36340,36342,36343,36345,36346,36348,36349,36351,36352,36354,36355,36358,36357,36360,36361,36363,36370,36377,36387,36397,36399,36400,36408,36409,36414,36415,36424,36430,36432,36435,36442,36444,36449,36450,36451,36454,36455,36458,36459,36461,36464,36468,36469,36470,36471,36474,36473,36472,36475,36476,36478,36479,36482,36484,36485,36487,36489,36491,36493,36495,36496,36498,36501,36502,40237,40287,40288,40289,40290,40291,40292,40293,41936,46691,47456,47457,47459,47460,47941,47943,47945,47948,47951,47952,47954,47955,47956,47957,47958,47963,47965,47966,47967,48309,48339,48340)) OR (categoryID IN (1036)) ) AND ( enabled=1) AND status_off <> 1