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 (839,840,841,842,2601,4999,5000,5001,5002,5383,5384,5391,5392,37575,5795,6159,6189,10347,10983,11534,12782,12873,14377,37576,37573,37574,17475,18649,20827,20981,20982,20983,20999,21045,23244,23806,23807,23808,26771,32511,32510,32509,32512,37577,39777,39779,39787,39788,39896,39938,46163,46164,46165,46166,46657,46661,46662,46807,46810,48056,48058,48177,50360,50706,50793,50794,50867,4989,4999,5000,5349,5364,5365,5366,5367,5368,5369,5370,5372,5373,5374,5375,5383,5384,5387,5444,5445,5581,5582,5584,5585,5586,5587,5589,5795,6189,9834,9835,17905,17918,18649,20904,20905,20906,21292,23244,23324,23325,23326,23815,23816,34210,35433,41279,39939,43217,46657,46661,46662,46807,2601,37574,6190,6191,6358,7155,7160,7163,10347,10983,10984,12462,12463,14377,14415,37575,17905,17906,17919,18595,21292,23238,23806,23807,23808,29459,29461,29462,35494,35498,35645,35644,37576,37577,39939,43217,4812,4813,4814,4945,4946,4958,4959,4960,4988,5365,5366,5367,5369,5370,5374,5375,7155,7160,7163,17906,17907,17908,17919,28076,29454,29453,29455,35498)) OR (categoryID IN (733,734,735,736,737,732)) ) AND ( enabled=1) AND status_off <> 1