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 (720,722,723,815,832,834,866,874,875,876,925,1124,1555,1933,2921,3009,3010,3013,3017,5015,5093,5444,5456,5461,5468,6218,7237,7240,7945,9241,9245,13477,14341,14753,14758,14821,15549,15850,15857,15865,16138,16139,16140,17203,17208,17209,17210,17213,17214,17225,17227,17884,17949,22883,23238,23822,25147,25148,26375,26419,26422,28198,28199,29406,29414,29434,48966,18766,31195,31337,31983,31984,32250,32260,35621,48200,37825,37826,39884,39886,39889,39892,39947,48615,43026,43661,44084,44087,44927,44959,45113,45143,45648,45666,45670,46512,47072,47233,47244,47308,47330,47325,47355,47362,47368,47428,48496,48497,48498,48499,48500,48501,48505,49130,49149,49151,49165,49288,49310,49371,49408,49409,49418,49468,49533,49660,49671,49681,49699,49714,49717,49722,49788,49799,49805)) OR (categoryID IN (636)) ) AND ( enabled=1) AND status_off <> 1