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 (768,778,779,791,792,884,985,987,1009,1035,1036,1037,1038,1039,1040,1041,1042,1048,1065,1066,1073,1076,1077,1114,1115,1122,1123,1129,1130,1131,1132,1136,1137,1138,1139,1147,1148,1149,1150,1151,1152,1171,1172,1173,1174,1190,1197,1198,1199,1224,1225,1307,1311,1315,1316,1328,1329,1355,1356,1529,1530,1531,1534,1535,1536,1547,1550,2153,2157,2264,2269,2299,2365,2368,2416,2445,2571,2572,2589,2591,2592,2667,2674,2681,2689,2692,2713,2716,2722,2842,2843,2895,2897,2901,2903,2906,2916,2918,2920,2922,3034,3035,3036,3039,3040,3042,3052,3058,3065,3073,3080,3129,3132,3153,3157,3308,3309,3313,3314,3328,3329,3381,3422,3564,4025,4232,4234,4273,4276,4279,4281,4284,4290,4406,4407,4408,4410,4414,4426,4427,4431,4432,4433,4435,4436,4439,4440,4441,4732,4733,4734,4735,4736,4745,4746,4747,4751,4752,4753,4754,5009,5011,5044,5065,5092,5095,5380,5381,5404,5406,5407,5408,5446,5451,5458,5473,5476,5529,5536,5544,5567,5568,5593,6115,6116,6155,6157,6163,6178,6181,6183,6210,6214,6222,6243,6246,6255,6257,6278,6279,6296,6326,6336,6494,6495,6783,6788,6789,6797,6798,6799,6816,6817,6818,6834,6835,6836,6840,6926,6927,7013,7014,7015,7198,7769,7784,7799,7800,8429,8439,9456,9473,9474,9486,10710,10839,10840,10856,10857,10872,10908,10909,10912,10913,10928,10969,10970,10971,10972,10973,10974,10993,10994,10995,10996,11005,11075,11076,11083,11084,11095,11096,11111,11112,11115,11142,11143,11146,11147,11150,11152,11153,11154,11155,11179,11181,11209,11211,11234,11236,11237,11256,11257,11259,11260,11292,11293,11295,11296,11313,11314,11316,11317,11355,11357,11384,11385,11387,11388,11456,11458,11460,11468,11505,11506,11519,11521,11536,11558,11559,11560,11561,11578,11580,11582,11585,11586,11864,11865,11940,12069,12070,12141,12155,12197,12200,12218,12222,12226,12235,12256,12258,12259,12275,12350,12355,12374,12375,12376,12377,12378,12379,12380,12381,12382,12383,12387,12391,12461,12580,12604,12607,12674,12776,12817,12818,12819,12820,12853,12854,12870,12900,12901,12959,12993,12994,12997,12998,12999,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13052,13053,13054,13055,13056,13057,13058,13059,13060,13061,13062,13063,13064,13065,13066,13067,13068,13069,13070,13071,13072,13073,13074,13075,13076,13077,13161,13162,13163,13164,13476,13483,13543,14308,14311,14315,14320,14325,14326,14329,14331,14335,14338,14339,14347,14350,14357,14372,14384,14391,14411,14441,14442,14443,14475,14520,14523,14527,14528,14632,14633,14634,14635,14636,14695,14696,14697,14698,14699,14700,14701,14703,14706,14820,14887,14993,14995,15057,15097,15235,15377,15548,15800,15801,15872,15873,15879,15931,16281,16396,16397,16409,16410,16422,16425,16478,16479,16494,16497,16503,16507,16508,16516,16518,16617,16621,16626,16650,16658,16696,16698,16701,16705,16775,16791,29933,17128,17130,17192,17218,17252,17284,17470,17474,17480,17485,17492,17496,17499,17510,17663,17679,17680,17681,17729,17731,17732,17740,17763,17767,17768,17769,17770,17771,17772,17773,17774,17777,17778,17780,17781,17783,17786,17828,17849,17855,17856,17858,17869,17870,17873,17874,17875,17876,17877,17878,17881,17882,17894,17895,17896,17897,17898,17913,17916,17936,17939,17942,17948,17950,18318,18435,18436,18440,18441,18487,18490,18503,18587,18602,18620,18641,18650,18651,18658,18659,18661,18662,18666,18667,18681,18693,18731,18753,18944,19233,19240,19241,19304,19305,19335,19349,19355,19358,19476,19482,19486,19632,19633,19634,19645,19646,19648,19675,19740,19741,19750,19761,19764,19867,20230,20234,20237,20373,20374,20375,20377,20378,20379,20467,20468,20469,20471,20472,20473,20474,20475,20494,20495,20496,20501,20502,20503,20504,20505,20506,20508,20509,20510,20511,20512,20513,20514,20515,20518,20519,20520,20521,20522,20523,20525,20526,20572,20573,20574,20575,20578,20579,20580,20639,20640,20641,20645,20646,20651,20712,20715,20719,20720,20721,20727,20728,20739,20742,20752,20755,20762,20763,20764,20768,20769,20770,20771,20772,20773,20774,20775,20780,20781,20782,20783,20784,20789,20798,20799,20808,20809,20813,20814,20833,20834,20835,20844,20845,20901,20953,20954,20955,20956,20958,20959,20961,20962,20963,20964,20985,20986,20987,21003,21011,21034,21041,21046,21047,21048,21066,21075,21078,21079,21091,21096,21097,21110,21111,21121,21131,21132,21158,21159,21162,21166,21171,21180,21186,21190,21191,21199,21201,21202,21203,21223,21224,21225,21227,21228,21229,21254,21255,21256,21257,21259,21260,21261,21262,21263,21264,21265,21293,21296,21320,21338,21339,21342,21343,21444,21445,21446,21447,21448,21449,21450,21451,21452,21471,21472,21473,21474,21486,21488,21489,21494,21500,21501,21502,21507,21509,21511,21512,21518,21519,21522,21523,21525,21535,21536,21537,21538,21539,21540,21541,21542,21543,21545,21546,21547,21548,21550,21551,21552,21553,21554,21555,21556,21558,21559,21560,21561,21563,21564,21565,21575,21576,21577,21578,21583,21584,21585,21586,21598,21600,21601,21602,21604,21605,21606,21607,21609,21610,21611,21612,21613,21614,21618,21619,21625,21626,21627,21628,21629,21630,21631,21632,21633,21637,21638,21639,21640,21641,21643,21644,21645,21646,21648,21649,21650,21652,21653,21654,21657,21659,21660,21661,21662,21663,21664,21666,21668,21669,21670,21671,21673,21674,21687,21688,21689,21690,21692,21693,21694,21695,21702,21703,21704,21705,21706,21707,21708,21709,21710,21711,21712,21713,21715,21745,21746,21747,21749,21750,21751,21752,21753,21763,21779,21789,21791,21793,21797,21799,21800,21816,21820,21827,21828,21830,21875,22048,22050,22057,22085,22086,22087,22088,22089,22090,22091,22092,22093,22094,22095,22096,22097,22098,22099,22100,22101,22102,22103,22104,22105,22106,22107,22108,22109,22110,22111,22112,22113,22114,22115,22116,22117,22122,22131,22137,22141,22142,22159,22160,22487,22532,22537,22541,22547,22548,22554,22555,22556,22557,22565,22568,22569,22578,22623,22624,22628,22632,22635,22682,22691,22703,22715,22716,22722,22724,22862,22880,22881,22882,22887,22893,22894,22912,23052,23060,23085,23088,23109,23110,23117,23125,23126,23206,23209,23220,23221,23222,23223,23224,23226,23227,23229,23230,23346,23828,24024,24078,24085,24195,24687,25061,25063,25150,25151,25170,25172,25174,25194,25193,25195,25196,25197,25198,25199,25200,25201,25202,25203,25205,25204,25206,25253,25294,1064,1062,1063,25414,25418,25420,25433,25436,25441,25469,25515,25606,25677,25678,25688,25689,25723,25725,25735,25737,25743,25753,25754,25755,25758,26764,26804,26811,26816,26850,27023,27066,27078,27081,27099,27224,27226,27234,27256,27271,27272,27983,28046,28070,28074,28145,28146,28273,28275,28295,28298,28301,28345,28349,28367,28368,28370,28375,28377,28378,28383,28385,28386,28441,28448,28447,28450,28451,28452,28455,28456,28459,28458,28460,28463,28462,28464,28466,28467,28468,28469,28470,28482,28483,28487,28496,28497,28498,28499,28546,28547,28548,28549,29131,29636,29637,29641,29642,29643,29644,29645,29646,29647,29648,29649,29650,29651,29652,29653,29659,29660,29661,29662,29676,29677,29678,29679,29680,29681,29682,29683,29684,29762,29763,29764,29934,29959,29963,30106,30105,30152,30153,30154,30155,30195,30198,30203,30202,30226,30243,30247,30255,30274,30281,30285,30286,30306,30318,30321,30324,30387,30627,30641,30640,30647,30815,30862,30874,18754,31051,31190,31191,31194,31231,31230,31237,31238,31246,31245,31258,31360,31362,31444,31443,31445,31446,31447,31448,31449,31451,31452,31453,31454,31455,31456,31457,31458,31459,31460,31937,39563,32454,32455,32456,32457,32460,32461,32462,32463,32464,32483,32484,32525,32524,32526,32528,32527,32543,32544,32545,32546,32547,32548,32549,32552,32551,32553,32554,32555,32556,32557,32558,32559,32560,32561,32562,32563,32564,32565,32566,32567,32568,32569,32570,32571,32572,32573,32574,32575,32576,32577,32578,32579,32858,32868,32873,32896,32897,32938,32962,32965,32969,32970,32973,32994,33005,33040,33055,33060,33062,33066,33069,33077,33089,33090,33257,33259,33270,33294,33307,33310,33317,33318,33348,33354,33355,33368,33370,33371,33763,34452,34020,34039,34047,34084,34085,34086,34115,34119,34123,41662,34211,34697,34953,35032,35043,35044,35082,35130,35140,35159,35420,35618,35655,35656,35657,35658,35659,35660,35826,35846,35860,35862,35867,35869,35871,36093,36174,36186,36519,36520,36521,36698,36709,36710,36862,36863,36864,36876,37006,37008,37030,37031,37032,37042,37043,37044,37053,37054,37055,37058,37061,37065,37066,37069,37070,37153,37154,37159,49038,49037,37254,37258,37292,37293,37294,37367,37369,37370,37371,37381,37385,37395,37399,37400,37408,37418,37419,37424,37431,37487,37514,37516,37520,37542,37543,37544,37545,37546,37547,37548,37549,37550,37551,37552,37583,37590,47661,47664,47668,38984,38993,38994,39124,39136,39150,39151,41971,39810,39814,39818,39819,39820,39821,39828,39829,39852,39853,39858,39859,39862,39887,39890,39961,39960,40012,40016,40040,48637,48594,40652,40653,40655,40654,40676,40677,40679,40678,40704,40706,40705,40707,40708,40709,33244,40710,40711,40712,40714,40874,40879,40880,40881,40883,40885,40887,40888,40895,40891,40901,40902,40911,40909,40913,40914,40925,40929,40934,40941,40953,40981,41001,41359,41363,41176,41177,41178,41179,41180,41181,41250,41249,41333,41428,41429,41430,41431,41432,41433,41434,41435,41475,41476,41478,41480,41481,41482,41488,41490,41511,41512,41513,41534,41537,41538,41545,41548,41559,41563,41564,41566,41567,41568,41580,41722,41723,41724,41725,41737,41738,41739,41740,41742,41741,41743,41744,41759,41760,41761,41762,41949,41957,41961,41965,41978,42117,42085,42086,42090,42091,42100,42099,42111,42112,42115,42122,42124,42282,42283,42362,42363,42364,42365,42366,42367,42440,42441,42442,42636,42671,42821,43036,43039,43045,43046,43047,43048,43049,43061,43060,43199,43201,43202,44613,44615,43218,43219,43221,43220,43224,43314,43315,43316,43317,43318,43320,43322,43325,43329,43330,43335,43361,43360,43362,43363,44710,43729,43730,43778,43777,32073,43860,43862,43861,43877,44046,44057,44060,44063,44066,44069,44070,44071,44073,44072,44074,44075,44098,44100,44102,44103,44110,44111,44112,44113,44114,44115,44116,44117,44118,44119,44120,44121,44122,44123,44124,44125,44126,44127,44128,44129,44130,44131,44132,44133,44137,44138,44139,44142,44146,44156,44161,44180,44181,44182,44183,44184,44555,44560,44563,44566,44567,44571,44574,44576,44578,44588,44610,44611,44633,44643,44647,44662,44703,44712,44713,44740,44744,47693,44946,44954,44967,44968,44969,44970,44971,43001,43002,12781,43015,43010,35507,45007,45043,45050,45109,45114,45142,45152,45177,45216,45223,45246,45248,45247,45249,45250,45251,45252,45254,45253,45255,45269,45427,45421,45424,45472,45477,45500,45584,45653,45658,45676,45677,45963,45966,45967,45968,46075,46098,46099,46106,46107,46116,46158,46161,46527,46549,46550,46642,46643,46675,46676,46707,46708,46756,46758,46759,46788,46789,46863,46864,46865,46866,46867,46868,46869,46873,46954,46955,46956,46962,46970,47032,47039,47042,47056,47055,47084,47205,47204,47207,47227,47235,47251,47381,47454,47458,47773,47782,47794,47795,47798,47801,47813,47812,47819,47867,47871,47873,47879,47882,47884,47911,47912,47913,47980,47984,48019,48026,48025,48080,48084,48166,48208,48212,48213,48214,48215,48216,48217,48218,48227,48229,48252,48253,48254,48267,48334,48419,48458,48462,48467,48479,48485,48490,48493,48504,48508,48514,48517,48520,48522,48563,48564,48570,48593,48834,48835,48836,48837,48842,48843,48899,49059,49060,49065,49066,49067,49068,49069,49070,49087,49091,49096,49101,49103,49104,49148,49150,49154,49398,51253,49835,49836,49837,49838,49839,49840,49841,49842,49847,49848,49849,50033,50036,50374,50373,50375,50376,50377,50378,50380,50379,50381,50382,50387,50412,50413,50414,50415,50424,50476,50479,50509,50521,50533,50540,50547,50556,50557,50529,50561,50563,50595,50617,50619,50623,50624,50626,50627,50703,50704,50708,50711,50715,50729,50730,50735,50736,50869,50870,50876,50893,50894,50998,50999,51000,51001,51002,51003,51004,51005,51014,51013,51045,51048,51117,51136,51196,51197,51198,51199,51200,51201,51203,51202,51204,51205,51206,51207,51208,51217,51218,51219,51220,51233,51234,51235,51236,51237,51238,51239,51240,51244,51245,51250,51249,51251,51252,51254,51255,51256,51257,51258,51269,51285)) OR (categoryID IN (606)) ) AND ( enabled=1) AND status_off <> 1