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 (1013,1014,1015,1019,1020,1021,1022,1023,1050,1051,1340,2384,2588,2590,2597,2858,2872,2873,2874,2875,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,2990,3020,3116,3117,3148,3149,3181,3182,3183,3184,3190,3191,3192,3205,3206,3207,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,3411,3412,4244,4245,4257,4258,4269,4270,4272,4282,4285,4605,4707,4708,4709,4712,4713,4716,4718,4719,4720,4721,4722,4723,4724,4737,4750,4761,4762,4763,5049,5051,5386,5430,5431,5432,5433,5538,5539,5540,5548,5794,5795,5796,5797,5798,5799,5800,5801,5802,6160,6212,6241,6244,6245,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6775,6776,6777,6778,6784,6785,6794,6795,6796,6801,6802,6803,9487,9632,10349,10803,10805,10806,10895,10896,10897,10905,10906,10911,10916,10918,10921,10922,10923,10926,10930,10931,10934,10936,10939,10940,10942,10960,10961,10962,10975,10976,10977,10978,11002,11088,11089,11107,11108,11126,11127,11129,11131,11136,11137,11138,11139,11289,11290,11347,11534,11643,11750,11932,11933,11934,11935,12148,12151,12153,12243,12249,12252,12253,12257,12348,12349,12353,12354,12599,12643,12644,12645,12646,12647,12648,12658,12659,12660,12664,12665,12666,12667,12668,12669,12789,12790,12791,12798,12799,12800,12801,12802,12803,12804,12805,12806,12807,12812,12813,12814,12815,12816,12825,12826,12827,12828,12829,12830,12831,12832,12833,12834,12837,12859,12861,12920,12927,12929,12931,14336,14337,14362,14363,14364,14422,14423,14424,14425,14426,14432,14433,14473,14690,14691,14723,14725,14728,14730,15031,15035,15040,15042,15043,15049,15052,15053,15055,15058,15064,15066,15067,15068,15069,15070,15071,15072,15175,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,15541,15542,15543,15544,15545,15892,15899,15933,16056,16061,16144,16149,16357,16377,16378,16379,16380,16381,16388,16389,16390,16404,16405,16406,16407,16408,16411,16412,16413,16414,16435,16436,16437,16438,16448,16449,16450,16451,16452,16457,16458,16481,16495,16512,16522,16523,16524,16525,16535,16539,16548,16550,16604,16606,16624,17125,17126,17276,17278,17281,17283,17463,17465,17476,17477,41304,18427,18428,18429,18430,18431,18432,18433,18505,18631,18632,18634,18654,18655,18679,18691,18694,18700,18703,18704,18713,18714,18715,18742,18743,18744,18756,18757,18758,18806,18819,18828,18829,18918,18940,18942,18947,18954,18957,18959,18960,18962,18965,18966,19256,20032,20042,20069,20090,20091,20092,20093,20453,20454,20455,20456,20457,20458,20459,20460,20461,20462,20585,20586,20716,20717,49040,20978,20988,20989,20990,20991,20992,20993,21002,21006,21007,21018,21019,21020,21021,21023,21024,21026,21027,21028,21029,21030,21050,21083,21084,21089,21112,21120,21281,21282,21283,21285,21286,21287,21297,21298,21299,21300,21301,21302,21303,21305,21307,21308,21309,21310,21311,21312,21313,21314,21315,21316,21317,21318,21319,21340,21438,21439,21440,21441,21453,21454,21455,21456,21457,21458,21459,21460,21461,21462,21463,21464,21465,21466,21467,21468,21469,21470,21481,21482,21483,21484,21485,21785,22076,22077,22138,22139,22140,22150,22151,22155,22157,22158,22558,22559,22897,22898,22899,22900,22901,22902,22903,22904,23055,23056,23057,23063,23064,23065,23103,23104,23111,23112,23129,23177,23178,23188,23189,30056,23817,23818,23890,23891,24811,24953,24954,24955,24956,24957,25021,25023,25024,25025,25027,25037,25038,25039,2443,25679,26768,26770,26771,26840,49039,27225,27227,27235,27240,27237,27238,27239,27241,27243,27245,27247,27249,27250,27257,27976,27977,27978,27979,27985,27986,27987,28184,28194,28193,28192,28312,28317,28319,28321,28322,28323,28338,28337,28339,28340,28341,28342,28359,28397,28398,28399,28400,28401,28402,28403,28404,28405,28407,28406,28449,28453,29469,29598,29601,29605,29656,29658,29667,29668,29669,29670,29942,29943,29944,29947,29948,29950,29951,29970,29968,29971,29969,29975,29974,29977,29978,30046,31065,31066,31067,31151,31152,31153,31173,31175,31176,31570,31571,31572,31573,31574,31575,31592,31593,31594,49034,39564,32488,32489,32490,32497,32498,32499,32500,32501,32502,32503,32504,32505,33093,33094,33096,33098,33099,33102,33105,33104,33106,33115,33116,33261,33262,33264,33277,33949,34108,34109,34110,34111,34112,34079,34080,34081,34087,34088,34091,34092,34093,34094,34122,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,34215,48938,34949,34950,35097,35098,35107,35108,35115,35116,35121,35122,35123,35124,35307,35308,35309,35310,35311,35312,35313,35314,35327,35328,35329,35330,35335,35336,35338,35337,35342,35343,35344,35345,35346,35347,35434,35436,35435,35437,35441,35442,35443,35444,48197,48196,36524,36533,36711,36868,36872,36878,37160,41315,41314,37483,37522,37525,37526,37529,37553,37554,37555,47703,41273,41271,41272,41277,41278,41279,39276,39822,39823,39856,41826,41824,41825,39975,39997,40001,40003,40004,40006,40007,40008,40009,40010,40011,40013,40014,40015,40017,40018,40019,40020,40021,40022,40023,40024,40025,40039,40268,40269,40271,40273,40274,40275,40278,40277,40276,40279,40280,40443,40473,40474,40475,40476,40477,40478,40479,40480,48649,48648,48647,48636,48634,48633,48632,48631,48630,48629,48628,41282,41280,40805,40808,40926,40927,40928,40935,40936,40937,40942,40958,40959,40960,41015,41022,41023,41041,41042,41043,41044,41045,41365,41366,41364,41368,41087,41085,41091,41121,41124,41125,41127,41130,41131,41132,41133,41134,41135,41136,41167,41168,41169,41170,41171,41172,41173,41174,41175,41182,41183,41184,41185,41186,41187,41188,41189,41190,41191,41242,41243,41244,41245,41248,41252,41254,41283,41285,41286,41287,41289,41305,41306,41307,41308,41310,41311,41312,41309,41313,41317,41318,41320,41321,41324,41327,41354,41355,41997,41956,41960,42385,42386,42408,42409,42679,42823,43038,43070,43071,43087,43086,43088,43091,43092,43093,43094,43097,43098,43100,43099,43101,43102,43103,43104,43105,43106,43107,43108,43109,43110,43132,43133,43134,43135,43136,43137,43138,43139,43143,43144,43145,43149,43150,44241,44242,44243,44244,44246,46678,44559,44582,44937,44940,44941,44942,44961,44962,44973,42994,42998,43020,43023,44978,44979,44980,44981,44982,44983,44984,44985,44986,44988,44987,44989,45018,45019,45020,45024,45025,45026,45027,45030,45031,45224,45225,45270,45271,45272,45273,45285,45290,45291,45292,45366,45368,45371,45374,45376,45378,45382,45654,45656,45661,45662,45663,45671,45672,45678,45959,45960,45961,45965,45969,45970,45971,46036,46070,46071,46084,46085,46086,46112,46114,46115,46124,46138,46153,46162,46351,46352,46353,46372,46375,46380,46385,46213,46217,46387,46582,46595,46659,46660,46661,46679,46702,46703,46709,46710,46714,46715,46721,46724,46725,46734,46735,46745,46746,46748,46749,46750,46780,46781,46808,46809,46811,46812,46813,46814,46852,46952,46953,47096,47106,47187,47188,47189,47190,47191,47192,47194,47193,47195,47196,47197,47198,47199,47200,47808,47809,47820,47821,47822,47887,47888,47889,47890,47891,47892,47909,47910,47911,47912,47925,47926,47929,47936,47944,48017,48022,48023,48024,48027,48028,48029,48030,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,48264,48265,48269,48270,48329,48330,48353,48354,48355,48356,48357,48358,48431,48432,48433,48434,48435,48437,48438,48439,48440,48441,48457,48459,48463,48510,48512,48513,48515,48524,48531,48919,49041,49042,49049,49050,49055,49056,49061,49062,49084,49085,49106,49107,49108,49109,49110,49646,49674,49675,49676,49825,49826,49827,49828,50417,50416,50420,50421,50422,50423,50425,50426,50427,50467,50469,50470,50534,50535,50536,50588,50598,50628,50629,50631,50661,50662,50666,50667,50697,50698,50699,50700,50701,50702,50705,50707,50783,50785,50886,50887,50911,50912,50913,50914,50915,50916,50917,50918,50919,50920,50921,50922,50923,50924,50972,50973,50974,50995,51023,51026,51027,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,51268)) OR (categoryID IN (600)) ) AND ( enabled=1) AND status_off <> 1