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 (6032,6034,6070,6071,6072,6074,6076,6077,6079,6088,6095,6102,6113,6391,6393,6395,6397,6399,6408,6411,7228,7231,7233,7235,8592,8605,8609,11949,11951,11952,11953,11954,11974,11975,11976,11977,11978,13184,14719,15747,15751,15753,15762,15764,15769,15772,16204,16225,16296,16307,16321,16326,16327,16328,16329,16330,16332,16532,16534,16537,16540,16543,16948,16961,16981,16982,16983,16984,16985,16986,16987,16988,16990,16992,17504,17735,17784,17794,17799,17807,17810,18173,18176,18178,18181,18185,18189,18197,18217,18221,18224,18262,18265,18267,18270,18272,18274,18454,18519,18522,18525,18529,18531,18533,18535,18536,18537,18538,18540,18541,18543,18544,18546,18548,18549,18550,18552,18553,18554,18556,18953,19007,19008,19011,19012,19027,19029,19031,19045,19046,19050,19055,19059,19067,19073,19074,19076,19078,19080,19083,19085,19086,19087,19088,20395,20399,20404,20406,20408,20422,20427,20429,20431,20434,20480,20483,20486,20489,20491,20656,20662,20676,20682,20683,20684,20685,20686,20689,20707,20708,20800,20801,20802,20854,20942,20945,20948,20949,20950,21360,21363,21365,21367,21369,22807,22809,22976,23263,23265,23267,23270,23281,23282,23284,23285,23288,23289,23291,23292,23296,23298,23300,23302,23304,23308,23310,23313,23315,23319,23928,23955,23958,23959,23986,24020,24023,24025,24184,24188,24189,24192,24194,24196,24967,24968,24969,24970,24993,24991,24992,24994,24997,24995,24996,24998,24999,25001,25011,25014,25012,25015,25016,25080,25119,25121,25123,25124,25126,25125,25127,25128,25164,25173,25175,25176,25177,25421,25422,25429,25432,25434,25435,25437,25453,25445,25448,25449,25450,25456,26136,26137,26150,26178,26162,26166,26182,26183,26184,26194,26208,26209,26567,26568,26569,26573,26575,26631,26633,26635,26637,26655,26657,26659,26661,26663,26665,26667,26669,26671,26673,26674,26675,26707,26709,26712,26714,26773,26776,26781,26779,26790,26793,26795,26797,26799,26932,26947,26936,26941,26944,26951,26954,26955,26962,26971,26978,26974,26981,26983,26985,26992,27000,27003,27006,27011,27013,27021,27026,27030,27035,27039,27047,27052,27056,27059,27062,27278,27283,27286,27288,27289,27295,27302,27303,27306,27307,27308,27311,27321,27326,27330,27340,27342,27344,27347,27352,27722,27742,27749,27750,27756,27760,27768,27773,27777,27783,27785,27786,27787,27791,27794,27795,27802,27801,27804,27816,27818,27823,27825,27830,27831,29088,29090,29098,29091,29093,29094,29095,29101,29110,29111,29109,29112,29114,29113,29126,29130,29132,29136,29322,29320,29321,29370,29374,29376,29873,29874,29877,29876,29886,29888,29891,29918,29927,29982,29984,29985,29987,29991,29995,30008,30016,30019,30022,30924,30931,30932,30936,30940,30944,30948,30953,30964,30973,30969,30978,30980,30986,30985,30989,30991,31080,31092,31106,31144,31630,31632,31631,31633,31634,31764,31761,31778,31785,31793,31801,31802,31805,31806,31808,31811,31865,31866,31867,31868,31869,31870,31890,31892,31893,31894,31895,31897,31896,31900,31898,31899,31901,31902,32029,32022,32031,32032,32034,32046,32050,32049,32052,32053,32054,32130,32131,32132,32164,32163,32162,32165,32166,32393,32392,32394,32395,32406,32407,32408,32409,32434,32435,32436,32437,32748,32761,32762,32763,32764,32765,33485,33488,33493,33495,33497,33502,33505,33506,33507,33508,33510,33514,33525,33528,33530,33683,33688,33690,33692,33694,33696,33699,33704,33702,33703,33705,33706,33711,33974,33999,34003,34001,34004,34005,33972,34006,34000,34009,33973,33975,34042,34048,34057,34058,34059,34060,34061,34062,34063,34064,34065,34098,34099,34100,34101,34105,34106,34107,34154,34155,34156,34157,34158,34159,34442,34524,34526,34528,34529,34530,20709,34744,34747,34746,34750,34816,34818,34820,34822,34823,34840,34842,34843,35555,35556,35557,35558,35559,36098,36099,36100,36101,36115,36116,36118,36117,36141,36140,36142,36143,36156,36157,36161,36162,36163,36436,36437,36438,36439,36440,36441,36536,36537,36540,36539,36541,36543,36545,36547,36559,36560,36561,36563,36564,36565,36583,36584,36585,36586,36587,36589,36590,36591,36663,36664,36665,36762,36763,36764,36765,36766,36767,36768,36769,36770,36771,36773,36772,36803,36804,36805,36884,36885,36886,36956,36958,36957,36960,36959,36961,36962,37116,37117,37118,37120,37121,37471,37472,37473,37476,37477,37478,37479,37770,37771,37772,37773,37774,37895,37897,37899,37901,37903,37999,38182,38195,38199,38201,38203,38204,38208,38210,38212,38215,38254,38259,38264,38269,38271,38274,38279,38281,38286,38288,38317,38452,38454,38456,38459,38466,38656,38658,38657,38662,38664,38665,38666,38674,38677,38685,38721,38724,38726,38732,38735,38737,38896,38909,38910,39234,39228,39230,39236,29309,29308,29252,39924,39928,39931,39942,39951,39954,41840,41841,39986,39993,41836,39999,41837,41034,41107,41112,41116,41117,41118,41199,41200,41202,41203,41204,41643,41648,41655,41776,41779,41843,41845,41846,41849,41850,41853,42261,42263,42265,42268,42269,42665,42678,42721,42722,42725,42726,42731,42732,42734,42736,42739,42948,42951,42953,42970,42973,42974,43271,43306,43307,43328,43321,43312,44032,44033,44034,44035,44038,44155,44159,44163,44166,44168,44175,44197,44200,44203,44206,44208,44209,44210,44212,44214,44217,44215,44220,44222,44224,44223,44227,44229,44247,44256,44260,44262,44302,44303,44515,44518,44520,44522,44524,44512,44510,44505,44528,44531,44534,44536,44621,44634,44667,44671,44675,44680,44684,44682,44687,44690,44694,44700,44733,44735,44727,44739,44872,44874,44876,44878,45440,45197,45298,45309,45346,45367,45381,45393,45394,45400,45407,45423,45451,45453,45567,45570,45569,45571,45573,45576,46198,46201,46291,46308,46309,46310,46311,49206,49208,49210,49212,49277,49280,49283,49286,49289,49291,49292,49305,49306,49308,49312,49314,49341,49354,49355,49356,49357,49358,49428,49438,49448,49446,49465,49471,49477,49819,49817,49820,49822,50049,50055,50072,50074,50076,50296,50305,50313,50317,50327,50651,50645,50648,50654,50657,50660,50851,50852,50855,50859,50861,50863,50905,50942,50944,50946,50948,50950,50952,50954,50955,50960,50956,50961,50963,50965,50970,50971,51071,51073,51075,51077,51079)) OR (categoryID IN (751)) ) AND ( enabled=1) AND status_off <> 1