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 (6374,6377,6378,6380,6381,6384,6386,6389,6852,6885,6906,6908,6909,6915,7745,7751,7755,7758,7759,7760,7763,7764,7906,7908,7915,7918,7924,7926,7927,7930,7932,7933,7982,7993,7997,7999,10305,10306,10308,10309,10310,10311,10312,10315,10316,10317,10698,10725,10728,10730,10733,10736,11766,11775,11781,11785,12089,12093,12094,12096,12099,12100,12102,13805,13806,13807,13809,13810,14774,14775,14776,14781,14783,14785,14790,15763,15776,16170,16173,16177,16178,16179,16187,16189,16191,16194,16197,16214,16215,16231,16232,16233,16236,16237,16238,16301,16302,16305,16306,16312,16313,16314,16325,16327,16329,16331,16531,16533,16536,16538,16542,16665,16687,16926,16927,16928,16930,16934,16938,16940,16941,16943,16946,16976,18328,18329,18330,18331,18332,18333,18456,18457,18464,18468,18469,18520,18523,18526,18530,18533,18535,18537,18543,18548,18552,18556,18562,18563,18566,18569,18572,18598,18601,18604,18605,18937,18939,18941,18946,18949,18951,18972,18974,18976,18978,18981,18984,19033,19037,19042,19044,19074,19078,19597,19608,19644,20307,20396,20397,20398,20403,20405,20407,20421,20426,20428,20430,20432,20918,20919,20921,20923,20926,20930,20931,20934,20936,20938,20940,20952,21346,21348,21350,21351,21353,21374,21384,21385,21386,21389,21392,21393,21717,21719,21792,21796,21798,21803,21806,21808,21810,21814,21899,21902,21904,21906,21908,22439,22459,22470,22480,22580,22597,22600,22602,22606,22608,22612,22613,22616,22618,22620,22786,22788,22790,22808,22810,22977,23262,23264,23266,23269,23281,23284,23288,23291,24151,24152,24155,24160,24164,24168,24170,24180,24181,24182,24183,24185,24188,24197,24205,24206,24207,24225,24299,24307,24312,24313,24314,24315,24320,25130,25131,25132,25223,25224,25225,25226,25248,25457,25460,25464,25468,25472,25474,26257,26254,26255,26258,26259,26260,26262,26309,26310,26314,26312,26316,26317,26318,26466,26489,26490,27386,27385,27387,27395,32211,32212,32213,32214,32215,32210,42838,32417,32415,32416,32418,32636,32668,32669,32667,33461,33463,33462,33721,33722,33723,33724,33725,33726,33728,33727,33729,33730,33731,33732,33733,33734,33735,33736,33737,34259,34261,34310,34308,34312,34315,34317,34319,34322,34327,34329,34331,34638,34639,34640,35147,35148,35149,35150,35151,35152,35153,35154,35155,35156,35157,35295,35296,35297,35298,35299,35300,35677,35678,35679,35680,35681,35682,35683,35706,35705,35707,35708,36551,36553,36555,36657,36656,36658,36774,36998,37000,37122,37123,37125,37124,37126,37874,39685,38111,38141,38144,38150,38153,38166,38169,38173,38180,38597,38630,38631,38632,38633,38669,38672,38678,38680,38681,38782,38786,38784,38785,38885,38896,38909,38910,38921,38924,37001,39644,39647,39650,39649,39660,39671,39674,39679,39683,39693,39696,39705,39709,39714,39712,39922,39929,39933,40091,40113,40118,40157,40163,40201,37002,40215,40392,40396,40397,40408,40415,40435,40438,40450,40556,40558,40560,40563,40566,40570,40572,40574,40580,40577,40589,40602,40608,40622,40643,40751,40755,40757,40769,41234,41575,42196,42125,42123,42127,42130,42132,42136,42137,42140,42143,42145,42147,42188,42190,42192,42195,42197,42199,42200,42201,42202,42204,42203,42205,42206,42210,42207,42208,42209,42212,42211,42213,42214,42215,42216,42217,42218,42219,42220,42221,42222,42223,42224,42225,42226,42227,42228,42229,42230,42231,42232,42233,42234,42235,42236,42237,42238,42239,42240,42262,42264,42266,42267,42270,42398,42399,42400,42401,42402,42428,42429,42430,40760,42744,42740,42748,42749,42753,42797,42800,42803,42810,42814,42816,42822,42827,42832,42835,42842,42845,43757,43762,43766,43771,43892,43895,43906,43912,43917,43918,43921,43964,43975,43977,44003,44032,44033,44034,44035,44038,44270,44284,44291,44300,44330,44331,44332,44336,44337,44338,44343,44525,44530,44533,44535,35452,44624,44625,44629,44635,44638,44657,44672,44674,44777,44791,44795,44800,44807,44831,45207,45307,45349,45354,45606,45621,45609,45624,45638,45642,46293,46296,46299,46307,46325,49205,49207,49209,49211,49360,49315,49317,49359,49361,49362,49423,49431,49436,49442,49456,49459,49469,49864,49878,49883,49887,49888,49968,49975,49988,49994,50004,50100,50110,50127,50141,50142,50252,50256,50257,50261,50263,50264,50302,50304,50310,50312,50320,50324,50339,50345,50391,50393,50398,50401,50406,50409,50436,50439,50444,50448,50451,50456,50460,50482,50570,50572,50576,50584,50752,50760,50762,50767,50828,50829,50830,50833,50834,50836,50838,50840,50842,50844,50845,50849,50850,50928,50932,50934,50938,50940,51158,51148,51150,51153,51152,51162,51163,51169,51173,51183,51186,51190,51193)) OR (categoryID IN (752)) ) AND ( enabled=1) AND status_off <> 1