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 (1015,1019,1020,1021,1022,1023,1024,1025,1026,1056,1074,1168,1169,1170,1187,1188,1189,1221,1222,1223,1296,1299,1302,1327,1340,1522,1523,1526,1551,2384,2884,2909,2912,2913,2914,2915,2927,2928,2929,2930,2931,2932,2934,2936,2938,2939,2940,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2956,2958,2959,3047,3049,3050,3051,3116,3117,3225,3226,3227,3229,3230,3231,3233,3234,3235,3237,3238,3239,3240,3242,3243,3247,3248,3254,3255,3256,3257,3258,3262,3263,3264,3265,3266,3276,3277,3296,3315,3323,3324,3336,3350,3351,3352,3353,3354,3355,3378,3379,3406,3407,3409,3410,4257,4258,4269,4270,4272,4282,4285,4308,4311,4312,4598,4599,4605,4707,4708,4709,4712,4713,4716,4721,4722,4737,4742,4743,4744,4750,4761,4762,4763,5393,5394,5471,5480,5481,5482,5483,5493,5538,5539,5540,5548,6160,6212,6244,6245,6309,6311,6312,6313,6314,6315,6316,9482,9485,9487,32080,10349,10709,10895,10896,10897,10916,10918,10921,10922,10923,10926,10930,10931,10934,10936,10939,10940,10942,11002,11088,11089,11107,11108,11126,11127,11129,11131,11136,11137,11138,11139,11469,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11661,11932,11933,11934,11935,49041,12148,12151,12153,12249,12252,12253,12257,12599,12798,12799,12800,12801,12802,12803,12812,12813,12815,12816,12825,12826,12827,12831,12832,12833,12834,12837,12859,12861,12865,12920,12927,12929,12931,13546,13683,13684,14362,14363,14364,14432,14433,14439,14446,14448,14449,14455,14456,14690,14691,14723,14725,14728,14730,14893,15042,15043,15049,15052,15053,15055,15058,15064,15066,15067,15068,15069,15070,15071,15072,15148,15149,15150,15151,15152,15154,15157,15160,15162,15168,15169,15170,15171,15172,15173,15174,15175,15212,15213,15214,15215,15216,15217,15218,15219,15220,15221,15228,15231,15233,15236,15279,15280,15281,15282,15285,15286,15287,15288,15289,15290,15326,15327,15328,15329,15330,15331,15332,15333,15336,15344,15347,15358,15359,15360,15361,15362,15363,15364,15366,15367,15368,15382,15391,15392,15393,15394,15395,15396,15397,15398,15399,15400,15401,15402,15403,15404,15408,15414,15416,15418,15421,15424,15436,15438,15439,15440,15441,15442,15443,15444,15445,15446,15459,15460,15462,15463,15464,15466,15473,15478,15495,15507,15519,15522,15527,15537,15544,15545,15892,15899,15933,16061,16068,16071,16072,16073,16144,16377,16378,16379,16380,16381,16382,16383,16388,16389,16390,16406,16407,16408,16411,16412,16413,16414,16435,16436,16437,16446,16447,16448,16449,16450,16451,16452,16457,16458,16477,16480,16481,16482,16483,16484,16486,16487,16489,16490,16495,16501,16624,16627,16652,16657,16806,16808,17180,17193,17194,17228,17230,17281,17283,17360,17361,17362,17369,18679,18691,18694,18700,18703,18704,18713,18714,18715,18742,18743,18744,18756,18757,18758,18799,18954,18957,18959,18960,19706,19721,19722,20032,20042,20069,20090,20091,20092,20093,20453,20454,20455,20456,20457,20458,20459,20460,20461,20462,20649,20650,20716,20717,20718,20846,49040,20978,21002,21006,21007,21019,21020,21083,21084,21085,21089,21112,21120,21181,21182,21183,21204,21205,21206,21207,21208,21209,21210,21299,21300,21301,21302,21303,21305,21307,21308,21309,21310,21311,21312,21313,21314,21315,21316,21317,21318,21319,21340,21418,21438,21439,21440,21441,21453,21454,21455,21456,21457,21458,21459,21460,21461,21462,21463,21464,21465,21466,21467,21468,21469,21470,21497,21498,21528,21529,22076,22077,22120,22121,22155,22157,22158,22546,22558,22559,22683,22684,22692,22693,22694,22695,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,22877,22878,22879,22884,22885,22886,22910,22911,23055,23056,23057,23103,23104,23111,23112,23188,23189,30056,23831,24811,24953,24954,24955,24956,24957,25021,25023,25024,25025,25027,25028,25029,25030,25031,25032,25033,25034,25035,25036,25037,25038,25039,25168,25169,25630,25631,25637,25640,2479,2443,25679,26768,26770,26771,27895,27896,27897,27976,27977,27978,27979,27985,27986,27987,28312,28317,28319,28321,28322,28323,29517,29518,29598,29601,29605,29656,29658,29667,29668,29669,29670,29942,29943,29944,29970,29968,29971,29969,29977,29978,30046,31067,31151,31152,31153,31172,31570,31571,31572,31573,31574,31575,31592,31593,31594,34870,34871,34872,32465,32466,32467,32468,32469,32470,32471,32472,32473,32488,32489,32490,32541,32542,34873,34874,33102,33264,33266,33277,34111,34112,34079,34080,34081,34087,34088,34141,34142,34143,34144,34145,34146,34147,34148,34149,34150,34151,34152,34153,34186,34187,34212,34213,34214,34215,34698,34857,34858,34859,34860,34863,34949,34950,35097,35098,35107,35108,35115,35116,35317,35318,35319,35320,35327,35328,35329,35330,35335,35336,35339,35340,35341,35342,35343,35344,35345,35346,35347,35352,35355,35367,35368,35434,35436,35437,35441,35442,35443,35444,41280,48197,48196,36524,36533,36711,39871,49039,48938,47703,41272,41271,41273,41275,41274,41276,41277,41279,39717,39775,39776,39777,39779,39782,39786,39787,39788,39868,39874,39893,41826,39935,41824,41825,40006,40007,40008,40009,40010,40011,40013,40014,40015,40017,40018,40019,40022,40023,40024,40025,40266,40265,40264,40267,40271,40272,40273,40274,40275,40278,40277,40276,40279,40280,40318,41278,40403,40404,40405,40427,40428,40443,40473,40474,40475,40476,40477,40478,40479,40480,40800,40801,40813,40816,40926,40927,40928,40942,40958,40959,40960,41355,41354,41366,41365,41364,41368,41130,41131,41132,41133,41134,41135,41136,41167,41168,41169,41170,41171,41172,41173,41174,41175,41182,41183,41184,41185,41186,41187,41248,41252,41254,41317,41318,41320,41321,41346,41940,41956,41960,42679,42823,43038,43087,43086,43088,43094,43143,43144,43145,43149,43150,44253,44251,44259,44257,44261,44265,46678,44937,44940,44941,44942,44973,43020,43023,44981,44982,44983,44984,44985,44986,45020,45022,45023,45030,45031,45034,45273,45277,45278,45279,45280,45281,45282,45283,45284,45285,45366,45368,45371,45374,45376,45654,45656,45678,45965,45969,45970,46036,46084,46085,46086,46124,46138,46153,46162,46280,46282,46351,46352,46353,46372,46375,46385,46380,46387,46582,46595,46679,46702,46703,46709,46710,46714,46715,46721,46724,46725,46734,46735,46745,46746,46748,46749,46750,46780,46781,46790,46791,46792,46793,46794,46796,46808,46809,46812,46813,46811,46814,46852,46945,46946,46952,46953,47057,47074,47075,47076,47077,47078,47079,47096,47202,47203,47206,47208,47216,47217,47218,47219,47220,47221,47809,47808,47820,47821,47822,47887,47888,47889,47890,47891,47892,47909,47910,47925,47926,47929,47936,47944,47947,47949,48017,48022,48023,48024,48027,48028,48045,48046,48054,48056,48058,48086,48088,48096,48098,48099,48209,48210,48211,48233,48235,48236,48237,48238,48239,48240,48246,48250,48251,48260,48261,48265,48269,48270,48329,48330,48353,48354,48355,48356,48357,48358,48442,48443,48444,48445,48446,48457,48459,48463,48919,49042,49055,49056,49061,49062,49105,49646,49674,49675,49676,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,50911,50912,50913,50914,50915,50916,50917,50918,50919,50920,50921,50922,50923,50924,50972,50973,50974,50995,51043,51044,51123,51126,51139,51140,51143,51144,51145,51209,51210,51211,51212,51213,51214,51215,51216,51221,51222,51223,51224,51225,51226,51227,51228,51229,51230,51231,51232,51260,51259,51261,51262,51263,51264,51265,51266,51267,51268,51278,51286)) OR (categoryID IN (598)) ) AND ( enabled=1) AND status_off <> 1