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 (1586,1601,1635,1707,1708,2039,3745,3828,3829,3830,3831,3984,3985,4047,4048,4062,4063,4066,4067,4077,4078,4081,4082,4085,4086,4095,4096,4097,4315,4316,4336,4675,4679,5120,5122,5166,5635,5722,5723,9467,11838,11839,11860,11861,11928,11929,11930,12038,12039,12073,12119,12209,12210,12211,12590,12593,14500,14504,14507,14508,14510,14607,14608,14779,14780,15048,15194,15198,15199,15200,15409,16315,16316,16317,16350,16372,16785,16788,16877,17093,17094,17096,17254,17255,17256,17263,17370,17397,17398,17399,17400,17438,17439,17440,17441,17559,17688,17689,17691,18025,18026,18028,18029,18401,18499,20257,21408,21530,21531,21532,21533,21534,21566,21568,21570,21571,21572,21592,21593,21668,21669,21672,21673,21674,22793,22794,22915,22916,22917,22918,22919,22920,22921,22925,22926,22937,22938,22939,22940,23022,28426,23753,23754,23966,23969,24071,24072,24077,24079,24395,24396,26759,26758,27915,27916,27925,27926,27932,27933,27934,27998,27999,28014,28051,28077,28078,28079,28130,28133,28134,28183,28213,28217,28221,28224,28264,28428,28473,28472,28476,28477,28488,28489,28492,28493,28577,28579,28966,28967,28975,28976,28981,28982,29039,29040,29042,29043,29045,29046,29048,29049,29070,29072,30136,30137,30138,30140,30141,30142,30143,30144,30145,30146,30147,30148,30450,30453,30455,30921,30922,30923,30954,30956,30957,30959,30960,30961,30968,30970,30972,31016,31017,31019,31020,31031,31032,31034,31035,31047,31048,31049,31050,31318,31319,31323,31503,31504,32068,33241,33779,33782,33915,33916,33933,34690,34691,34692,34740,35278,35246,35250,35253,35279,35587,35795,35799,35814,35815,35855,35856,36064,36065,48943,39437,39438,39446,39447,39484,39529,39530,39624,39639,39721,40251,40253,40291,40292,40293,40364,16322,40593,40792,42096,42097,42098,43457,43461,43490,43491,43519,43518,43634,43635,43741,43747,43816,43822,43827,45009,45012,45011,45115,45117,45122,45123,45124,45146,46402,46403,46404,46405,46407,46409,46415,46417,46420,46421,46422,46423,46470,46471,46480,47440,47442,47456,47457,47459,47460,48167,48230,48234,48288,48309,48310)) OR (categoryID IN (697)) ) AND ( enabled=1) AND status_off <> 1