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 (1552,1554,1555,1563,1564,1565,1576,1581,1582,1583,1584,1593,1597,1598,1599,1600,1614,1621,1624,1628,1630,1643,1644,1655,1656,1657,1658,1659,1663,1670,1675,1690,1693,1696,1697,1698,1702,1704,2449,2454,2455,2456,2464,2506,2522,2523,2531,2893,3801,3802,3807,3983,3986,3987,4089,4318,4319,4321,4323,4327,4328,4329,4334,4339,4340,5229,5230,5632,5633,5634,5638,5639,5640,5641,5669,5670,5671,5721,5803,5804,5805,5806,5807,5808,5811,5812,5813,5814,5816,5817,5818,5819,5820,5827,5828,5829,5831,6455,6456,11496,11497,11503,11814,11838,11839,11885,11886,11888,11891,11892,11901,11902,11903,11905,11913,11915,11916,11918,11919,11928,11929,11930,12071,12072,12076,12085,12088,12098,12325,12326,12558,12567,12568,12572,12581,12582,12583,12585,12889,13553,14461,14463,14581,14582,14916,15079,15086,15087,15119,15153,15155,15158,15159,15379,15380,16896,17034,17035,17048,17049,17103,17104,17105,18934,18935,19861,19862,20248,20249,20383,20384,20388,20463,21412,24465,24462,22980,24125,24128,24129,24130,24157,24158,24162,24166,24169,24171,24176,24177,24209,24210,24229,24230,24404,24405,24469,24468,24544,24545,24636,24637,24672,24674,24708,24709,24710,24713,24714,24715,24724,1569,1629,1631,1634,27923,27924,27925,27926,27931,28014,28013,28032,28034,28127,28265,29054,29055,29057,29058,31278,31279,31423,32249,32250,32580,32582,33192,33193,33195,33198,33200,33202,33201,33203,33211,33552,33553,33576,33578,33580,33582,33583,33590,33607,33615,33619,33622,33623,33624,33636,33635,33637,33757,33758,33759,33760,33769,33775,33776,33915,33916,33936,12590,35504,35505,35517,35518,35585,35586,35612,35613,35614,35852,35853,47687,47686,47690,37285,37296,37297,37302,37303,39089,39119,38843,38844,39154,39156,39163,39166,39188,39189,39190,39570,39572,39581,39588,39589,39609,39610,39612,40242,41972,41975,42306,42310,42325,42326,44544,44546,44545,47691,47692,44914,44915,45131,45132,45150,45151,45154,45156,45157,45203,45204,45205,45289,45288,47305,48406,50362,50363,50513)) OR (categoryID IN (573)) ) AND ( enabled=1) AND status_off <> 1