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 (6938,6940,6941,6942,6943,6945,6946,6952,6953,6954,6955,6956,6957,6958,6959,7247,7249,7738,7739,7741,7743,7747,7753,7756,7761,7762,7765,7775,7786,7789,10287,10289,10291,10294,10295,10305,10309,10311,10315,10317,14824,14911,14914,15112,15303,15305,15307,15309,15314,15322,15323,34251,15749,15752,15756,15757,15763,15766,15770,15776,16170,16177,16178,16179,16187,16189,16191,16193,16194,16196,16197,16749,16750,16751,16754,16755,16841,16855,16858,16926,16927,16930,16934,16936,16938,16940,16941,16943,16944,16946,16947,16948,16952,16953,16958,16961,16965,16967,16969,16970,16971,16973,16974,16976,16978,16979,16989,18328,18330,18331,18347,18348,20662,20666,20669,20671,20672,20674,20675,20683,20685,20686,20687,20688,20690,20692,20697,20700,20701,20707,20800,20801,20802,20803,20851,20853,20854,20915,20918,20919,20920,20921,20922,20923,20925,20926,20927,20930,20931,20934,20936,20938,20940,20942,20945,20948,20949,20950,21345,21347,21349,21352,21354,21356,21358,21374,21376,21377,21378,21384,21385,21386,21388,21389,21392,21393,21397,21717,21719,21790,21792,21795,21796,21798,21802,21803,21805,21806,21808,21810,21812,21814,21847,21848,21856,21861,21862,21865,21869,21871,21876,21878,21899,21902,21904,21906,21908,21911,21913,21917,21919,21923,22439,22446,22451,22459,22462,22470,22477,22480,22481,22580,22586,22589,22591,22592,22595,22612,22613,22616,22618,22620,22778,22780,22783,22785,23308,23310,23313,23315,23319,24271,24272,24273,24274,24275,24276,24277,24278,24280,24291,24292,24293,24971,24972,24973,25079,25089,25173,25164,25176,25175,25177,25178,25180,25182,25183,25211,25212,25214,25213,25238,25239,25241,38977,25243,25242,25244,25246,25245,25247,26231,26246,26245,26250,26248,26252,26254,26255,26257,26258,26259,26260,26262,26309,26310,26314,26312,26316,26317,26318,26330,26328,26331,26333,26342,26346,26348,26347,26349,26352,26350,26351,26353,26461,26462,26463,26464,26465,26478,26466,26473,26480,26481,26482,26483,26484,26485,26486,26487,26488,26490,26489,26699,26701,26703,26705,41879,38976,31837,31841,31842,31843,31844,31845,31846,31847,32144,32145,32146,32147,32177,32178,32179,32180,32181,32182,32183,32184,32205,32206,32207,32208,32209,32204,32211,32212,32213,32214,32215,32210,32225,32226,32228,32229,32230,32224,42837,42818,25240,33974,33980,33979,33978,33976,33975,33973,33972,34235,34234,34236,34237,34239,34238,34252,34254,34255,34262,34264,34266,34268,34269,34270,34274,34277,34278,34280,34338,34355,34357,34358,34361,34363,34366,34369,34374,36641,36642,36644,36643,36683,36684,36685,36686,36940,36941,36942,36943,36944,36945,36998,37937,37942,37949,37962,38121,38115,38116,38117,38118,38119,38120,38123,38124,38125,38979,38184,38194,38214,38217,38228,38229,38240,38238,38244,38248,38251,38351,38354,38355,38358,38360,38495,38504,38506,38509,38521,38578,38574,38580,38581,38638,38642,38645,38648,40336,39062,39068,39131,38975,25248,39008,39012,39013,39016,39018,39022,39019,39020,39021,39133,39134,39139,39144,39146,39147,39415,39421,39425,37002,40316,40331,40334,40337,40380,40381,40382,41281,40392,40396,40397,40398,40395,40406,40407,40408,40409,40411,40414,40415,40417,40420,40421,40422,40433,40435,40436,40439,40438,40445,40448,40450,40460,40459,40463,37001,40814,41126,41128,41129,41212,41213,41234,41575,41700,41701,41704,41705,41707,41876,41877,41881,41914,41915,41917,42831,42037,42043,42044,42079,37000,42780,42778,42779,42783,42781,42782,42795,42799,42825,42840,42847,43247,43248,43637,43647,43651,43653,43655,43668,43669,43681,43683,43688,43685,43686,43689,43691,43710,43711,43733,43714,43712,43740,43739,43742,43745,43750,43748,43749,43760,43761,43770,43772,44079,44083,44086,44092,44094,44107,44109,42815,42809,44524,44522,44520,44518,35452,44624,49620,44635,44638,44672,44674,44777,44791,44795,44800,44853,44859,44855,44868,44894,44975,45085,45095,46302,46305,47492,47503,47508,47510,49229,49232,49234,49236,49238,49279,49276,49282,49285,49551,49552,49553,49555,49554,49558,49561,49565,49566,49568,49569,49570,49572,49574,49577,49578,49579,49581,49583,49584,49588,49587,49589,49593,49595,49596,49598,49600,49602,49604,49606,49608,49609,49618,49619,49622,49623,49624,49628,49629,49631,49633,49635,49636,49640,49641,49642,49643,49644,49686,49687,50007,50011,50013,50014,50016,50018,50024,50028,50025,50029,50045,50046,50047,50051,50052,50054,50053,50057,50058,50061,50064,50066,50067,50073,50069,50075,50078,50077,50109,50114,50122,50147,51007,51009,51011,51018,51025,51033,51035,51037,51050,51051,51053,51055,51057,51059,51061,51063,51069,51065,51068,51071,51073,51075,51077,51079,51081,51083,51085,51088,51089,51154,51159,51161,51170,51175,51176,51186,51190,51183,51193)) OR (categoryID IN (742)) ) AND ( enabled=1) AND status_off <> 1