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 (1184,1185,1608,1776,2924,2925,3528,3529,3757,3803,4103,4586,4841,5082,5087,5130,5680,5824,5825,5826,6467,11906,11912,12024,12028,12044,12285,12458,12563,12670,12772,13189,13190,13254,13275,13276,13296,13297,13320,13321,13329,13330,13335,13336,13337,13338,13339,13340,13342,13348,13357,13363,13371,13387,13388,13404,13412,13420,13427,13437,13438,13447,13448,13463,13464,13474,13495,13512,13522,13523,13530,13531,13541,13558,13560,13561,13583,13590,14284,14496,15016,15095,16937,17113,17238,17576,17580,17582,17612,18406,19079,19089,21770,21772,21773,21775,22631,22802,22895,22896,22959,22960,22971,22979,23010,23121,24717,26329,28001,28065,28209,28600,28602,30595,30605,30606,30616,30617,30619,30636,30730,30731,30733,30741,30743,30744,30765,30780,30790,30843,30844,30845,30846,31216,31289,31329,31342,31343,31556,33649,33927,33934,33937,33948,34501,34525,35583,35892,36024,37362,38019,38020,38834,38838,39439,39460,39586,40983,43496,43511,43560,43629,43698,45104,47349,47358,49116)) OR (categoryID IN (691)) ) AND ( enabled=1) AND status_off <> 1