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 (774,1317,1357,1358,1914,2097,2101,3124,5149,5438,5439,5440,5441,5469,5537,5543,41378,41377,11250,11251,11286,11287,11319,11320,11351,11372,11373,11439,11440,11462,11464,11488,11500,11501,11502,11507,11508,11517,11518,11527,11528,11529,11537,11552,11553,11554,11555,11556,11557,11590,11591,11597,11598,11622,11624,11634,11635,11639,11640,11641,11672,11674,11676,11693,11694,11709,11715,11718,11723,11729,11732,11738,11741,11744,11906,11912,12526,12528,12808,12809,12810,12811,13228,13229,13230,13231,13480,14297,14342,14395,14419,14772,15135,15140,15554,15869,15877,16147,18692,18695,18696,18698,18699,18772,18854,18921,18923,18932,18933,19382,19384,19385,19389,19390,20902,20994,20995,20996,20997,20998,21031,21098,21153,21807,21813,22553,23107,23108,23190,23813,23935,24964,26264,26827,28006,28065,29765,29769,29771,29774,29777,31501,31988,32862,33120,33122,33124,33872,33888,33893,33897,33906,33918,33922,33930,33934,33937,34038,34051,34077,34116,34130,34190,34191,34192,34193,34194,34195,34196,34762,34767,34966,34969,34972,34971,34970,35354,35357,36531,37406,37425,37426,37485,38834,38838,38968,39535,39554,39568,39586,40632,40636,40983,41046,41047,41966,42092,42093,43028,43033,43394,43398,43442,43511,43524,43525,43548,43551,43553,44997,46100,46108,46287,46360,46368,46391,46526,46548,46640,46674,46706,46950,47281,47284,48144,48372,48373,48374,48375,48376,48377,48378,48379,49824,50285,50286,50287,50527,50709,50731,50737,50909,50910,50925,50926,51271)) OR (categoryID IN (761)) ) AND ( enabled=1) AND status_off <> 1