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,1587,1608,1650,1669,1694,2010,2023,2052,2350,2413,2565,3088,3094,3095,3101,3102,3514,3515,3521,3522,3528,3529,3545,3877,3918,3919,4014,4019,4021,4022,4023,4031,4387,4811,4841,4855,4923,5032,5130,5138,5689,5976,6449,6462,6467,6757,6862,6868,6869,7062,7112,7512,7922,7939,7961,8322,11352,11597,11598,11615,11617,12024,12028,12044,12061,12285,12458,12539,12676,12886,12887,13186,13188,13189,13190,14419,14480,15016,16814,16817,16846,16859,16893,16898,16909,17026,17119,17563,17569,17943,18031,18300,18308,18316,18385,18421,18422,19058,19068,19487,19554,19738,19927,23023,26264,1714,24725,28048,41855,29263,29265,29300,29301,29317,30500,30501,30510,30511,30523,30524,30544,30545,30552,30553,30570,30571,33649,33947,33951,34501,34525,34543,34551,34973,34974,34975,34979,34980,34983,37277,37362,37698,37699,37712,37738,37739,37855,37856,38023,38024,47601,47609,39412,39492,41884,43406,43437,45100,47402,48898,49119,49126,49132,49179,49374,49380,49907)) OR (categoryID IN (611)) ) AND ( enabled=1) AND status_off <> 1