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 (29025,28184,28259,29026,28947,28948,28951,28952,28954,28955,28987,28991,28992,28989,28990,28993,29030,29031,29033,29034,29036,29037,29054,29055,29057,29058,29060,29061,29063,29064,29077,29078,29084,29085,29099,29128,29137,29140,29144,29146,29147,30005,30015,33192,33200,33585,33622,33627,33657,35821,35822,35824,35827,35837,35841,35842,35847,35849,35850,35852,35863,35864,35874,35875,35876,35878,35881,35883,35886,35890,35990,35991,36008,36010,36014,36056,36057,36061,36062,36187,36389,36390,36404,36452,36453,36504,36505,36507,36509,36511,36513,36515,40240,40241,40242,40243,40244,40273,40274,40275,47972,47973)) OR (categoryID IN (1035)) ) AND ( enabled=1) AND status_off <> 1