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 (1027,1028,1029,1030,1031,1032,1033,1034,1057,1058,1059,1060,1061,1074,1168,1169,1170,1187,1188,1189,1296,1340,1525,1526,1527,1528,2119,2384,2939,2944,2945,3047,3049,3050,3066,3116,3117,4308,4311,4312,4712,4713,4716,4721,4722,4737,4742,4743,4744,4750,4761,4762,4763,5471,5480,5481,5482,5483,5493,6160,6212,6244,6245,6309,6311,6312,6313,6314,6315,6316,9482,9485,32080,10349,10709,10895,10896,10897,10916,10918,10921,10922,10923,10926,10930,10931,10934,10936,10939,10940,10942,10960,10962,11002,11088,11089,11107,11108,11289,11290,11347,46084,11469,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11661,39871,11914,11917,12252,12253,12667,12668,12669,12828,12829,12830,12920,12927,12929,12931,13546,13683,13684,14319,14324,14362,14363,14364,14446,14448,14449,14690,14691,14723,14725,14728,14730,15042,15043,15049,15052,15053,15055,15058,15064,15066,15067,15068,15069,15070,15071,15072,15168,15169,15170,15171,15172,15173,15174,15175,15212,15221,15236,15279,15280,15285,15286,15333,15336,15344,15347,15358,15359,15360,15361,15362,15363,15364,15444,15445,15446,15459,15460,16382,16383,16388,16389,16390,16406,16411,16412,16413,16414,16446,16447,16448,16449,16450,16451,16452,16457,16458,16462,16477,16480,16481,16482,16483,16484,16486,16487,16489,16490,16501,16624,16806,16808,17193,17194,17281,17283,17303,17304,17305,17360,17361,17362,18713,18714,18715,18742,18743,18744,18756,18757,18758,19723,19726,20649,20650,20716,20717,20718,20846,49041,49040,21002,21006,21007,21021,21023,21024,21026,21027,21028,21029,21030,21083,21084,21085,21089,21112,21120,21181,21182,21183,21204,21205,21206,21207,21208,21209,21210,21285,21286,21297,21298,21299,21300,21301,21302,21303,21305,21307,21308,21309,21310,21311,21312,21313,21314,21315,21316,21317,21318,21319,21340,22076,22077,22120,22121,22155,22546,22683,22684,22719,22720,22725,22728,22847,22848,22849,22850,22851,22852,22853,22854,22855,22856,22858,22859,22863,22864,22865,22866,22867,22868,22869,22870,22871,22872,22873,22874,22875,22876,22884,22885,22886,22910,22911,23103,23104,23112,23177,23178,23188,23189,23831,24811,24954,24955,24956,24957,25021,25023,25027,25028,25029,25030,25031,25032,25033,25034,25035,25036,25037,25038,25039,25168,25169,2479,26768,26770,26771,27225,27227,27235,27240,27237,27238,27239,27241,27243,27245,27247,27249,27250,27257,27901,27902,27976,27977,27978,27979,27985,27986,28317,28319,28321,28322,28323,28449,28453,29598,29601,29605,29656,29658,29667,29668,29669,29670,29942,29943,29944,29947,29948,29950,29951,29970,29968,29971,29969,29975,29974,29977,29978,31173,31987,34880,34877,32465,32466,19721,1523,32467,19722,1551,32468,32469,32470,19706,1522,32471,32472,32473,32488,32489,32490,32497,32498,32499,32500,32501,32502,32503,32504,32505,32541,32542,34879,34878,34881,34875,34876,33115,33116,33261,33262,33264,33266,33277,34108,34109,34110,34111,34112,34079,34080,34081,34087,34088,34091,34092,34093,34094,34134,34135,34136,34137,34138,34139,34140,34141,34142,34143,34144,34145,34146,34147,34148,34149,34150,34151,34152,34153,34186,34187,34212,34213,34214,35097,35098,35107,35108,35115,35116,35121,35122,35123,35124,35309,35310,35311,35312,35313,35314,35318,35317,35319,35320,35321,35322,35323,35324,35325,35326,35332,35333,35334,35339,35340,35341,35367,35368,35434,35436,35437,35441,35442,35443,35444,48197,48196,36711,49039,48938,41315,41314,37553,37554,37555,47703,41275,41274,41271,41276,39532,39531,39533,39537,39822,39823,39849,39850,39856,39868,39874,39893,39935,41824,41825,41826,39997,40001,40003,40004,40006,40007,40008,40009,40010,40011,40013,40014,40015,40017,40018,40019,40020,40021,40022,40023,40024,40025,40039,40273,40274,40275,40278,40277,40276,40279,40280,40318,40327,40328,40339,40338,40348,40349,40473,40474,40475,40476,40477,40478,40479,40480,40482,40481,40483,48649,48648,48647,48634,48636,48633,48632,48631,48630,48629,48628,40800,40801,40805,40808,40813,40816,40926,40927,40928,40936,40935,40937,40942,40958,40959,40960,41015,41022,41023,41354,41355,41041,41042,41043,41044,41045,41069,41072,41074,41076,41077,41078,41087,41085,41091,41121,41124,41125,41127,41167,41168,41169,41170,41171,41172,41173,41174,41175,41182,41183,41184,41185,41186,41187,41188,41189,41190,41191,41243,41242,41244,41245,41282,41283,41285,41286,41287,41289,41304,41305,41306,41307,41308,41310,41311,41312,41309,41313,41317,41318,41320,41321,41940,41956,41960,42679,42823,43038,43070,43071,43087,43086,43088,43091,43092,43094,43149,43150,43792,44241,44242,44243,44244,44246,44973,42994,42998,43020,43023,45019,45022,45023,45030,45031,45034,45277,45278,45285,45290,45291,45292,45366,45368,45371,45374,45376,45654,45656,45671,45672,45678,45959,45960,45961,45965,45969,45970,46036,46085,46086,46112,46114,46115,46124,46138,46153,46162,46282,46280,46372,46213,46217,46351,46352,46353,46375,46385,46380,46436,46582,46595,46678,46679,46702,46703,46709,46710,46721,46714,46715,46745,46748,46790,46791,46792,46793,46794,46796,46852,46945,46946,46952,46953,47096,47194,47193,47195,47196,47197,47198,47199,47200,47210,47209,47216,47217,47218,47809,47808,47821,47820,47822,47888,47887,47889,47890,47891,47892,47909,47910,47911,47912,47926,47925,47929,47936,47944,47949,47947,48017,48022,48023,48024,48029,48030,48045,48046,48054,48056,48058,48086,48088,48098,48096,48099,48209,48210,48211,48233,48235,48236,48237,48238,48239,48240,48250,48260,48261,48265,48269,48270,48442,48443,48444,48445,48446,48524,48531,48919,49042,49049,49050,49055,49056,49061,49062,49105,49646,49674,49675,49676,49825,49826,49827,49828,50417,50416,50420,50421,50422,50423,50425,50426,50427,50534,50535,50536,50588,50598,50628,50629,50631,50661,50662,50666,50667,50697,50698,50699,50700,50701,50702,50705,50707,50783,50785,50865,50866,50867,50886,50887,50898,50899,50900,50901,50995,51023,51026,51027,51144,51260,51259,51261,51262,51263,51264,51265,51266,51267,51268,51278,51286)) OR (categoryID IN (597)) ) AND ( enabled=1) AND status_off <> 1