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 (5934,5936,5939,6071,6076,6145,6148,6151,6152,6156,6184,6188,6325,6329,6330,6333,6335,6337,6340,6341,6342,6352,6357,6359,6364,6368,6370,6374,6377,6378,6380,6381,6384,6386,6389,6406,6415,6418,6420,6422,7228,7231,7233,7235,7244,7246,7250,7251,7253,7255,8004,8008,8009,8599,8602,8608,8622,8752,8754,8755,8760,9910,9916,9917,10281,10282,10283,10287,10289,10290,10291,10293,10294,10295,10296,10297,10298,10299,10300,10301,10303,10304,10305,10306,10308,10309,10310,10311,10312,10313,10315,10316,10317,10318,10320,10325,10327,10330,10332,10337,10340,10341,10343,10345,10665,10673,10676,10690,10698,10700,10701,10716,10717,10720,10721,10724,10725,10727,10728,10730,10732,10733,10735,10736,11764,11772,11774,11776,11778,11779,11782,11783,11786,12160,12163,12164,12167,12170,12173,12174,12176,12179,12181,12183,12184,12186,12187,13184,14776,14785,14831,14833,14835,14836,14838,14839,14843,14852,14858,14913,14948,14954,14955,14956,14957,14958,15106,15299,15308,15311,15312,15317,15318,15320,15321,15729,15730,15731,15732,15733,15734,15735,15736,15737,15738,15739,15748,15750,15755,15759,15760,15761,15763,15765,15767,15768,15771,15773,16173,16176,16178,16179,16189,16197,16209,16211,16212,16213,16214,16218,16228,16229,16230,16231,16232,16233,16235,16236,16294,16299,16304,16305,16306,16309,16310,16311,16323,16325,16327,16329,16331,16333,16337,16340,16342,16344,16529,16531,16533,16536,16538,16542,16549,16551,16557,16562,16564,16569,16572,16574,16666,16683,16685,16687,16693,16702,16727,16750,16751,16752,16753,16756,16840,16857,16926,16927,16928,16930,16934,16936,16938,16940,16941,16943,16944,16946,16950,16951,16954,16956,16960,16963,16968,16971,16976,16993,16996,16999,17736,17776,17791,17796,17800,17814,18143,18148,18152,18179,18193,18194,18196,18198,18220,18223,18228,18250,18251,18252,18253,18254,18261,18263,18266,18269,18271,18273,18328,18329,18330,18331,18332,18333,18337,18338,18339,18340,18341,18342,18343,18344,18345,18346,18351,18352,18353,18354,18355,18356,18359,18362,18363,18364,18365,18366,18367,18368,18369,18370,18371,18372,18456,18457,18464,18466,18469,18520,18523,18526,18530,18542,18547,18551,18555,18605,18971,18973,18975,18977,18980,18983,19013,19015,19021,19023,19026,19028,19030,19057,19064,19615,19699,19702,20286,20290,20298,20300,20307,20312,20396,20397,20398,20403,20405,20407,20411,20413,20415,20417,20419,20421,20426,20428,20430,20432,20481,20484,20487,20488,20490,20658,20659,20660,20663,20664,20667,20668,20670,20673,20677,20678,20679,20691,20693,20695,20698,20699,20702,20703,20705,20852,20918,20919,20921,20923,20926,20930,20932,20935,20937,20939,20941,20943,20944,20946,20947,20951,20952,21346,21348,21350,21351,21353,21355,21357,21359,21361,21362,21364,21366,21368,21374,21376,21377,21378,21384,21385,21386,21388,21389,21392,21393,21397,21717,21719,21729,21732,21734,21764,21767,21771,21792,21796,21798,21803,21806,21808,21810,21814,21849,21857,21859,21863,21866,21874,21888,21899,21902,21904,21906,21908,21912,21915,21918,21921,21925,22440,22443,22454,22457,22466,22469,22479,22579,22581,22582,22583,22584,22585,22587,22588,22593,22594,22596,22597,22599,22600,22602,22606,22607,22608,22611,22612,22613,22614,22615,22616,22617,22618,22619,22620,22642,22646,22649,22652,22656,22661,22675,22777,22781,22782,22784,22786,22788,22790,22808,22810,22977,23262,23264,23266,23269,23283,23286,23287,23290,23293,23294,23295,23297,23299,23301,23303,23307,23309,23311,23314,23316,23317,23320,24151,24152,24155,24160,24164,24168,24170,24180,24181,24182,24183,24185,24188,24192,24196,24291,24323,24326,24327,24329,24330,24333,24979,24980,24981,24982,24983,24984,25002,25003,25004,25018,25115,25116,25117,25118,25129,25130,25131,25132,25153,25154,25155,25156,25157,25159,25158,25160,25161,25215,25216,25217,25218,25219,25220,25221,25222,25231,25232,25233,25235,25234,25236,25237,25404,25405,25406,25407,25408,25409,25410,25411,25457,25460,25464,25468,25472,25474,25488,25489,25491,26829,27744,27746,27758,27764,27772,27776,27789,27798,27806,27810,27814,27821,27828,27829,27833,30164,30165,30167,30170,30171,31765,31766,31769,31795,32008,32009,32010,32011,32012,32013,32014,32015,32016,32017,32018,32036,32037,32038,32039,32040,32041,32042,32043,32044,32045,32065,32064,32066,32067,32093,32092,32094,32095,32096,32097,32098,32099,32139,32140,32141,32142,32154,32153,32155,32156,32157,32158,32159,32160,32161,32167,32168,32169,32170,32171,32185,32186,32187,32188,32299,32300,32301,32313,32316,32315,32317,32324,32354,32355,32356,32357,32372,32347,32374,32373,32353,32495,32496,32529,32531,32530,32532,32796,32795,32797,32798,32799,32800,32801,32802,32803,32804,32815,32814,32816,32817,32818,32819,32820,32821,33296,33419,33420,33421,33422,33423,33492,33494,33500,33503,33516,33517,33518,33520,33523,33531,33533,33537,33712,33713,33714,33715,33716,33717,33718,33719,33721,33724,33722,33723,33725,33726,33727,33728,33729,33730,33731,33734,33732,33733,33735,33736,33737,33841,33842,33843,33844,33845,33846,33925,33980,33979,33978,33976,34095,34180,34988,34991,34990,34993,35000,35002,35033,35034,35035,35036,35031,35037,35040,35041,35042,35527,35528,35529,35537,35538,35531,35532,35533,35534,35535,35536,35539,35808,35809,35810,35811,35812,36546,36548,36549,36550,36569,36571,36572,36570,36573,36580,36579,36581,36582,36599,36601,36600,36603,36602,36605,36604,36606,36607,36610,36608,36609,36611,36612,36613,36614,36615,36633,36634,36635,36636,36637,36739,36639,36640,36649,36648,36650,36651,36652,36653,36730,36731,36732,36733,36734,36735,36736,36737,36738,36742,36741,36743,36744,36780,36781,36782,36783,36784,36785,36852,36854,36860,36969,36970,36971,36972,36974,36973,36976,36977,36978,36979,36980,36981,36982,36984,36983,36985,37886,37892,37914,37916,37917,37918,37921,37924,37926,37929,37930,37934,38451,38453,38457,38455,38467,38468,38464,38476,38479,38481,38484,38485,38487,38488,38494,38657,38664,38674,38677,38685,38690,38699,38702,38704,38705,38706,38769,38770,38772,38773,38775,39172,39174,39175,39179,39176,39306,39419,36153,36154,36155,36158,36159,40598,40600,41235,41236,41237,41550,41551,41553,41552,41555,41556,41645,41652,41654,41774,41658,41775,41780,41783,41785,41789,41974,42021,42026,42028,42029,42040,42048,42052,42062,42065,42068,42076,42080,42164,42162,42165,42167,42168,42170,43285,43286,43287,43288,43297,43298,43451,43621,43622,43625,43627,43930,43934,43936,43939,43945,43947,43949,43958,43957,43961,43962,44966,45093,45559,45561,45565,45563,45568,45575,45828,45870,45883,48183,48184,48188,48190,49205,49206,49208,49207,49209,49210,49211,49212,49221,49223,49225,49227,49315,49317,49360,49359,49361,49362,49557,49567,49582,49585,49594,49597,49599,49625,49630,49639,49693,49692,49691,49800,49803,49806,49804,49807,49808,49810,49811,49814,49812,49813,49815,49816,50752,50760,50762,50767)) OR (categoryID IN (741)) ) AND ( enabled=1) AND status_off <> 1