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 (1732,2458,2460,2482,2483,2487,3804,3810,3812,3821,3982,3988,4049,4064,4080,4091,4098,5095,5180,5181,5226,5231,5233,5834,11876,11877,11904,11908,11921,12092,12113,12584,12895,12925,12926,13168,13169,13170,13171,15181,15191,15192,15195,15196,15201,15202,16453,16454,16504,17076,17077,17080,20260,20392,20465,20776,20777,20778,20779,20785,20786,20787,20788,21258,21289,21290,21291,21320,21404,21407,21409,21411,21429,21433,21477,21480,21567,21568,21569,21571,21572,21573,21574,21588,21589,21593,21594,21754,21755,21756,21757,21759,21760,21761,22575,22909,22922,22927,22928,28426,23204,23205,23207,23208,24045,24046,24054,24055,24073,24074,24082,24083,27200,27204,27206,27208,27966,27967,27969,27971,28215,28216,28428,30447,32069,32251,32261,33633,33634,34686,34689,34693,35358,35360,35362,35363,35765,35767,35785,35807,37300,37358,39121,39120,39579,39591,39590,39592,39794,40238,42298,42356,42357,42358,43045,43046,43047,43048,43049,43543,43545,43546,43559,44188,44189,44190,44191,44192,44193,45130,45256,45257,45635,46438,46763,46764,47110,47118,47433,47766,47767,47768,48166,48227,48259,48289,48290,48291,48292,48334,50716,50717,50718)) OR (categoryID IN (702)) ) AND ( enabled=1) AND status_off <> 1