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 (684,692,752,753,775,776,777,783,784,785,786,787,788,789,797,802,878,879,880,881,882,986,989,990,991,992,996,998,999,1004,1005,1006,1007,1011,1012,1047,1168,1180,1193,1194,1196,1361,1539,1540,1541,1542,1543,2089,2094,2117,2136,2140,2144,2288,2301,2302,2304,2384,2385,2418,2578,2604,2723,2857,2858,2859,2865,2866,2867,2871,2874,2875,2877,2879,2886,2905,2933,2939,2944,2945,2970,2971,2972,2985,2986,2987,2988,2989,2990,3002,3003,3004,3064,3075,3076,3077,3078,3081,3083,3084,3119,3127,3128,3130,3131,3139,3140,3141,3142,3150,3151,3159,3160,3170,3171,3176,3177,3178,3200,3201,3202,3203,3208,3209,3211,3213,3214,3216,3217,3249,3250,3272,3273,3274,3275,3280,3281,3282,3289,3290,3293,3294,3295,3296,3316,3317,3331,3332,3333,3337,3342,3343,3347,3369,3374,3380,3389,3390,3396,3419,3420,3421,3425,3426,3429,3430,3434,3435,3437,3438,3442,3443,3459,3460,3461,3476,3477,3479,3480,3492,3493,3503,3504,3508,3509,3531,3532,3533,3670,3671,3674,4251,4254,4255,4263,4264,4267,4268,4271,4274,4278,4280,4283,4286,4288,4289,4297,4298,4299,4300,4302,4303,4304,4305,4710,4711,4712,4713,4714,4715,4716,4717,4721,4722,4727,4728,4729,4730,4737,4739,4750,4761,4762,4763,5010,5049,5340,5342,5347,5348,5396,5400,5402,5403,5405,5443,5450,5453,5462,5463,5464,5467,5470,5484,5485,5486,5487,5488,5489,5490,5491,5503,5504,5505,5506,5507,5508,5509,5510,5511,5512,5513,5514,5515,5520,5521,5522,5523,5526,5527,5530,5531,5533,5545,5546,5547,5549,5550,5551,5553,5554,5555,5557,5558,5563,5564,5565,5566,5604,5991,41374,41373,6196,6197,6198,6200,6201,6202,6203,6206,6208,6209,6215,6218,6219,6223,6224,6225,6240,6259,6260,6261,6293,6294,6295,6297,6298,6302,6304,6305,6306,6307,6308,6332,6334,6740,6744,6748,6749,6750,6753,6903,6904,6996,6997,6998,7000,7001,7002,7005,7007,7009,7012,7746,7748,7749,7766,7767,7768,7780,7781,7794,7795,7796,7798,7945,7946,7947,8438,9769,9770,9771,9846,9847,10852,10853,10854,10855,10863,10864,10865,10867,10868,10869,10870,10871,10930,10979,10980,10981,10982,10985,10986,10991,10992,10997,10998,10999,11000,11002,11006,11007,11067,11068,11071,11072,11081,11082,11091,11097,11099,11100,11107,11108,11109,11110,11117,11118,11119,11120,11121,11122,11123,11124,11125,11128,11130,11131,11165,11166,11173,11174,11175,11176,11191,11192,11193,11195,11223,11226,11227,11244,11245,11246,11253,11254,11255,11274,11275,11280,11281,11301,11302,11303,11307,11308,11309,11325,11327,11329,11331,11333,11375,11376,11378,11379,11390,11391,11392,11402,11403,11442,11444,11454,11532,11533,11562,11563,11564,11565,11568,11569,11570,11571,11587,11588,11589,11600,11602,11604,11606,11619,11628,11632,11633,11638,11659,11660,11661,11746,11750,11936,11937,11938,11939,12204,12205,12215,12219,12223,12227,12231,12232,12233,12236,12237,12238,12240,12246,12586,12587,12635,12636,12773,12774,12783,12785,12835,12836,12843,12844,12845,12846,12860,12896,12897,12898,12899,13477,13478,13479,13482,14276,14279,14288,14302,14303,14304,14312,14313,14314,14327,14328,14330,14332,14333,14334,14340,14341,14344,14345,14346,14348,14349,14351,14355,14356,14358,14359,14360,14361,14370,14375,14376,14392,14393,14394,14398,14399,14400,14401,14403,14407,14408,14427,14428,14429,14430,14431,14470,14471,14474,14476,14516,14517,14524,14545,14546,14731,14733,14747,14748,14753,14758,14759,14773,14884,14885,14894,15003,15004,15083,15085,15091,15093,15262,15263,15264,15265,15266,15267,15268,15269,15270,15271,15272,15273,15274,15275,15276,15277,15287,15288,15289,15344,15347,15358,15359,15360,15361,15362,15363,15365,15405,15406,15407,15408,15414,15416,15418,15421,15424,15436,15438,15439,15440,15441,15442,15443,15444,15445,15446,15459,15460,15462,15463,15464,15466,15473,15478,15495,15507,15515,15519,15522,15527,15537,15544,15545,15549,15797,15802,15850,15857,15865,15867,15870,15871,15881,15882,15883,16063,16064,16138,16139,16140,16141,16142,16143,16356,16370,16371,16380,16381,16399,16400,16402,16403,16404,16405,16406,16407,16408,16415,16416,16417,16418,16419,16435,16446,16447,16457,16458,16463,16464,16465,16466,16481,16482,16483,16486,16495,17125,17126,17132,17199,17203,17208,17209,17210,17213,17214,17225,17231,17234,17262,17267,17269,17448,17453,17459,17461,17464,17469,17471,17482,17483,17494,17507,17511,17883,17884,17885,17949,18282,18439,18444,18445,18612,18655,18656,18660,18665,18670,18675,18680,18689,18697,18701,18702,18705,18706,18726,18727,18728,18729,18733,18734,18736,18738,18742,18749,18750,18766,18794,18806,18834,18840,18844,18850,18853,18869,18870,18871,18873,18875,18884,18952,18954,18957,18959,18960,18962,18966,19626,19629,19673,19674,19689,19751,19920,19921,19949,19961,19986,20025,20032,20049,20063,20075,20094,20095,20098,20101,20219,20225,20228,20229,20231,20232,20233,20235,20236,20451,20452,20453,20459,20460,20584,20592,20593,20738,20741,20743,20751,20754,20757,20791,20794,20797,20804,20807,20810,20828,20829,20830,20831,20832,20850,20855,20856,20857,20858,20859,20860,20871,20873,20887,20888,20893,20894,20895,20896,20898,20899,20900,20928,20929,20968,20969,20972,20973,20974,20975,20981,20982,20983,20999,21012,21013,21019,21020,21025,21042,21045,21049,21050,21051,21056,21065,21069,21072,21077,21100,21101,21102,21103,21112,21113,21114,21117,21120,21124,21125,21126,21127,21128,21129,21130,21142,21143,21144,21145,21146,21147,21183,21227,21228,21229,21281,21282,21292,21344,21778,22130,22139,22155,22156,22493,22494,22538,22883,22897,22900,22944,23051,23081,23083,23084,23086,23087,23099,23103,23104,23112,23124,23129,23330,23331,23332,23335,23336,23337,23338,23339,23341,23342,23343,23885,23891,23924,23926,23930,23933,24013,24038,24075,24076,24081,24811,24813,24812,24953,24954,24955,24956,24957,24958,25000,25010,25013,25017,25019,25020,25021,25022,25023,25025,25026,25027,25070,25069,25072,25133,25134,25139,25142,25171,25179,25181,25184,25185,25186,25187,25188,42991,26766,26765,26767,26769,26818,26820,27259,27276,27277,27897,27973,27987,27989,27988,28072,28141,28184,28292,28293,28294,28299,28300,28304,28307,28308,28313,28314,28315,28325,28328,28329,28395,28434,28892,29099,29140,29144,29146,29147,29466,29467,29560,29656,29657,29931,29932,29935,29936,29937,29938,29939,29940,29941,29956,29961,29962,29965,29970,29968,29971,29969,29976,29977,29978,30005,30015,48966,48967,48968,18759,31172,31177,31179,31180,31181,31183,31182,31188,31189,31192,31195,31197,31229,31228,31234,31235,31243,31242,31241,31244,31249,31275,31280,31332,31333,31375,31376,31584,31585,31586,31587,31588,31589,32231,32248,32449,32450,32451,32477,32478,32479,32506,32507,32508,32521,32522,32523,32603,32602,32604,32605,33112,33114,33113,33256,33263,33264,33268,33274,33275,33297,33323,33720,33762,33761,33765,33764,33766,33767,33768,34041,34052,34053,34055,34087,34088,34117,34118,34120,34121,34124,34125,34131,34188,35095,35096,35097,35098,35105,35106,35107,35108,35113,35114,35115,35116,35125,35126,35127,35128,35134,35135,35136,35138,35143,35144,35145,35146,35163,35164,35165,35204,35210,35211,35212,35418,35619,35620,35621,35661,35662,35663,35723,35729,35731,35733,35742,48207,36187,36516,36517,36518,36524,36527,36526,36525,36533,36534,36688,36689,36711,36713,36712,36850,36868,36871,36870,36869,36872,36875,36874,36873,36878,49036,37005,37004,37003,37023,37024,37025,37026,37035,37036,37037,37038,37046,37047,37048,37049,37161,37250,37251,37252,37255,37256,37257,37259,37260,37261,37267,37268,37382,37383,37384,37396,37397,37401,37402,37405,37409,37420,37421,37480,37481,37494,37533,37579,37580,37581,37586,37587,37588,48965,41271,41276,39081,39080,46167,46168,42992,39077,39076,39565,39566,39656,39808,39809,39824,39825,39830,39831,39832,39833,39883,39884,39885,39886,39888,39889,39891,39892,39945,39947,39949,39950,39963,39965,39974,39976,39977,39987,39988,39989,40002,40005,40007,40008,40010,40011,40015,40018,40019,40270,40273,40274,40275,40844,40848,40849,40851,48955,40889,40893,40916,40931,40932,40933,40954,40955,40963,40964,40965,40966,40974,40977,40978,40979,41360,41367,41246,41317,41318,41346,41350,41349,41352,41351,48956,48957,42001,42015,42369,42368,42417,42418,42419,42421,42438,42439,42444,42445,42462,42463,42464,42468,42632,42631,42667,42819,42856,42860,43041,43076,43096,43095,44618,44617,44616,44614,43370,43795,43796,43797,43798,43871,43872,43873,43874,43875,43876,48964,44556,44557,44558,44564,44565,44568,44569,44577,44579,44580,44581,44582,44583,44589,44590,44591,44612,44636,44640,44648,44660,44663,44704,44711,44714,44715,44716,44747,44748,44927,44947,43008,43007,12778,12777,43026,43022,44999,45001,45005,45006,45033,45036,45038,45047,45048,45049,45061,45062,45063,45066,45067,45068,45111,45113,45143,45144,45147,45148,45149,45175,45176,45198,45200,45211,45224,45225,45582,45581,45585,45586,45587,45601,45597,45603,45615,45618,45620,45648,45650,45649,45651,45652,45689,45691,45692,45693,46017,46018,46019,46024,46034,46035,46072,46073,46074,46076,46095,46103,46111,46121,46142,46141,46144,46147,46148,46149,46163,46164,46165,46166,46172,46173,46174,46268,46269,46270,46345,46346,46348,46349,46357,46358,46359,46363,46364,46365,46366,46367,46379,46381,46382,46383,46384,46344,46343,46510,46512,46519,46522,46523,46529,46538,46539,46540,46562,46565,46571,46575,46576,46578,46579,46581,46586,46587,46592,46594,46596,46601,46633,46634,46635,46636,46646,46647,46653,46654,46655,46656,46659,46660,46661,46666,46667,46668,46669,48067,46677,46680,46726,46761,46762,46773,46774,46775,46782,46783,46794,46796,46807,46810,47065,47109,47107,47116,47117,47121,47126,47253,47254,47256,47257,47261,47796,47823,47824,47825,48086,48088,48130,48131,48133,48134,48135,48136,48137,48140,48146,48149,48150,48152,48168,48170,48176,48177,48189,48192,48240,48296,48298,48460,48461,48464,48477,48486,48487,48496,48497,48498,48499,48500,48501,48505,48506,48509,48511,48530,49043,49044,49051,49052,49053,49054,49063,49064,49071,49072,49073,49074,49075,49076,49081,49082,49083,49086,49138,49139,49400,49677,49683,49724,49723,49818,49823,49852,49892,49940,49942,49943,50008,50009,50010,50017,50019,50020,50021,50026,50031,50030,50032,50037,50038,50039,50182,50177,50187,50188,50266,50271,50336,50338,50349,50351,50352,50357,50358,50359,50360,50361,50371,50372,50430,50465,50474,50475,50538,50543,50566,50562,50706,50710,50739,50738,50741,50742,50743,50786,50787,50788,50792,50793,50794,50881,50882,50884,50883,50979,50980,50981,50982,50983,50984,50985,50986,50987,50988,50989,50990,50992,50991,50993,50994,50996,50997,51015,51028,51029,51030,51031,51039,51040,51042,51120,51137,51275,51274,51276,51277,51279,51280,51282,51281,51283,51284)) OR (categoryID IN (576)) ) AND ( enabled=1) AND status_off <> 1