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 (6034,6355,6360,6362,6365,6369,6372,7910,7914,7917,7921,7925,7928,7981,7996,8000,11759,11761,11763,11765,12105,12108,12149,12154,12158,15313,15319,15747,15751,15775,16177,16323,16325,16326,16327,16328,16329,16330,16331,16332,16336,16338,16339,16341,16343,16345,16530,16543,16547,16555,16561,16567,16571,16663,16665,16667,16668,16669,16672,16681,16686,16687,16689,16690,16691,16692,16694,16695,16697,16699,16720,16722,16724,16729,16731,16733,16734,16981,16982,16983,16985,16986,16987,16988,16989,16990,18120,18127,18130,18135,18145,18146,18177,18179,18184,18234,18237,18240,18242,18245,18276,18281,18283,18285,18286,18288,18289,18291,18292,18294,18574,18948,18956,19007,19011,20421,20426,20428,20430,20432,20437,20439,20441,20443,20445,34065,21360,21363,21365,21367,21369,21382,21383,21387,21391,21395,21714,21847,21848,21850,21856,21861,21862,21864,21865,21869,21871,21876,21878,21897,21901,21903,21905,21907,21910,21911,21913,21914,21916,21917,21919,21920,21922,21923,22668,22669,22670,22671,22672,22673,22674,22676,22761,22764,22766,22768,22977,23262,23264,23266,23269,23281,23284,23288,23291,24127,24154,24159,24161,24163,24165,24271,24272,24273,24274,24275,24276,24294,24295,24296,24297,24298,24301,24304,24864,24888,24967,24968,24969,24970,24985,24986,24987,24989,24988,24990,24991,24993,24995,24997,24999,25011,25012,25014,25015,25016,25393,25396,25398,25397,25401,25402,25421,25422,25429,25432,25434,25435,25481,25478,25476,25482,25486,25487,26665,26669,26666,26667,26668,26670,26671,26672,26675,26676,27744,27821,27829,29151,29152,29155,29154,36592,36593,36594,36596,36597,31770,31771,31775,31782,31789,31798,31890,31892,31894,31893,31895,31896,31923,31925,31926,31927,31933,31932,31934,31955,31956,31957,31958,31968,31967,31969,28817,31991,31992,31993,32030,32028,32026,32025,32027,32033,32035,32056,32058,32061,32062,32107,32110,32112,32113,32111,32120,32121,32122,32125,32123,32124,32205,32206,32207,32208,32209,32204,33411,33413,33415,33490,33491,33532,33534,33536,33539,33542,33544,33974,33975,33973,33972,34061,34062,34063,34064,34098,34099,34101,34100,34305,41619,34417,34420,34422,34423,34424,34425,34426,34427,34428,34429,34644,34418,34569,34570,34571,34572,34584,34585,34586,34590,34591,34592,34594,34593,34595,34606,34609,34613,34612,34616,34622,34625,34623,34627,34629,34630,34632,34631,34633,34634,34635,34637,34636,34419,34641,34642,34421,34643,34568,34645,34662,34665,34663,34664,34666,34667,34757,34773,34775,34776,34777,34778,36595,35555,35556,35558,35557,35559,36250,36252,36253,36254,36560,36574,36575,36576,36577,36578,36589,36598,36786,36787,36788,36789,36790,36791,36806,36807,36808,36809,36810,36811,36848,36849,36851,36859,37202,37203,37204,37205,37326,37327,37328,37330,37331,37332,37333,37334,37335,37336,37338,37339,37340,37455,37456,37457,37458,37459,37460,37461,37462,37493,37497,37496,37495,37873,37875,37878,37880,37881,37910,37912,37915,37919,37920,37923,37924,37925,37926,37927,37929,37930,37931,37933,37934,37999,38095,38105,38112,38191,37944,38207,38218,38227,38236,38242,38247,38292,38298,38299,38302,38297,38306,38338,38339,38340,38343,38341,38342,38344,38345,38346,38347,38348,38349,38587,38588,38589,38590,38591,38739,38742,38744,38746,38761,38762,38765,38766,38767,39082,38889,38891,38897,38900,38903,38908,38914,38925,39233,39239,39273,39274,41470,41468,41467,39511,39514,39519,39522,39526,39715,39784,39785,39790,39791,39799,39800,39801,39803,39804,39806,39807,39924,39931,39986,39993,39999,40098,40087,40099,40100,40101,40102,40103,40105,40107,40112,40116,40147,40151,40150,40153,40155,40156,40158,40161,40172,40162,40192,40200,40206,40210,40207,40208,40209,40211,40212,40214,40217,41472,40590,41084,41090,41095,41101,41107,41112,41269,41270,41492,41497,41495,41496,41499,41498,41620,41605,41607,41609,41610,41612,41611,41615,41616,41617,41621,41618,41623,41624,41625,41627,41626,41628,41629,41630,41633,41631,41632,41634,41709,41712,41714,41731,41733,41735,41736,41867,41870,41874,41873,41862,41919,41921,41923,42102,42103,42126,42128,42131,42133,42134,42135,42139,42142,42144,42146,42150,42148,42152,42157,42155,42159,42161,42163,42166,42169,42171,42172,42173,42189,42176,42177,42178,42179,42181,42194,42182,42184,42186,42191,42193,42198,42435,42437,42449,42447,42544,42557,42563,42565,42589,42591,42590,42592,42538,42547,42559,42611,42613,42621,42731,42732,42734,42736,42739,41890,41889,42802,41892,41893,42834,42844,42851,42854,42858,42861,42865,42864,42866,42869,42871,42938,42942,42940,42943,42945,42947,42955,42957,42959,42961,42963,42965,42967,42968,42969,42971,42972,43307,43306,44007,44015,44022,44025,44024,44039,44051,44061,44056,44068,44077,44134,44140,44145,44152,44151,44157,44162,44164,44170,44172,44176,44177,44178,44179,44197,44200,44203,44206,44212,44208,44209,44210,44214,44538,44540,44543,44626,44621,44634,44667,44668,44671,44673,44675,44676,44680,44686,44688,44691,44692,44696,44699,44701,44880,44883,44885,44888,44911,44900,44924,44930,44935,44938,46211,46202,46208,46216,46220,46228,46230,46232,46236,46241,46243,46244,46250,46259,46263,46394,46395,46397,46399,46406,46419,46434,46449,46456,46461,46463,49214,49216,49218,49220,49430,49440,49466,49474,49475,49479,49480,50199,50200,50201,50208,50210,50211,50215,50214,50212,50342,50341,50388,50395,50396,50403,50404,50433,50434,50442,50441,50446,50453,50454,50458,50481,50568,50571,50575,50580,50583,50586,50599,50602,50603,50604,50607,50605,50608,50610,50612,50630,50634,50636,50639,50641,50643,50644,50645,50646,50648,50647,50649,50650,50651,50652,50653,50654,50655,50656,50658,50657,50659,50660,50676,50678,50680,50682,50684,50686,50688,50690,50692,50695,50740,50744,50748,50749,50751,50754,50755,50759,50758,50761,50766,50765,50769,50929,50931,50935,50937,50941,51091,51096,51094,51098,51100,51103,51105,51106,51108,51111,51112,51114,51115,51118,51119,51122,51124,51127,51128,51129,51131,51132)) OR (categoryID IN (745)) ) AND ( enabled=1) AND status_off <> 1