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,993,994,995,997,1009,1016,1017,1018,1048,1053,1114,1115,1197,1198,1199,1532,2206,2214,2226,2235,2242,2279,2323,2325,2340,2445,2476,2586,2603,2862,2868,2878,2887,2895,2897,2901,2903,2906,2916,2918,2920,41250,2964,2965,2982,2991,2995,3005,3022,3034,3035,3036,3073,3080,3104,3105,3109,3110,3129,3146,3153,3157,3179,3188,3189,3193,3194,3198,3204,3212,3215,3220,3223,3224,3298,3299,3300,3308,3309,3313,3314,3318,3328,3329,3341,3357,3358,3370,3381,3391,3418,3422,3427,3428,3436,3439,3478,3481,3510,3534,3666,3848,4243,4252,4253,4256,4273,4276,4279,4281,4284,4290,4431,4435,4436,4441,4732,4733,4734,4735,4736,5011,5354,5385,5389,5390,5395,5397,5401,5434,5435,5436,5437,5446,5524,5525,5536,5544,5552,5567,5568,5961,5963,5964,5988,41375,6115,6116,6171,6172,6173,6174,6175,6176,6178,6181,6183,6199,6207,6214,6220,6222,6246,6275,6296,6494,6495,6754,6755,6892,6893,6894,6895,6896,6897,6898,6899,6916,6919,7757,7948,7949,8378,8439,9473,9474,9773,9848,9849,10856,10857,10872,10928,10938,10969,10970,10971,10972,10973,10974,10993,10994,10995,10996,11005,11075,11076,11083,11084,11095,11096,11111,11112,11142,11143,11146,11147,11150,11152,11153,11154,11155,11179,11180,11181,11182,11209,11210,11211,11212,11234,11235,11236,11256,11257,11258,11259,11260,11261,11292,11293,11295,11296,11313,11314,11315,11316,11317,11318,11355,11357,11384,11385,11386,11387,11388,11389,11399,11400,11401,11436,11437,11438,11492,11536,11578,11579,11580,11581,11582,11583,11585,11586,11610,11612,11747,11748,11864,11865,11870,11871,11872,11873,11874,11875,11876,11877,11940,12141,12147,12155,12168,12191,12194,12203,12218,12222,12226,12230,12235,12245,12254,12256,12258,12259,12275,12350,12355,12368,12369,12370,12374,12375,12376,12377,12378,12379,12380,12381,12382,12383,12387,12391,12588,12598,12604,12607,12671,12776,12787,12817,12818,12819,12820,12862,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,13033,13034,13035,13036,13037,13038,13039,13042,13043,13044,13045,13046,13047,13048,13049,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,13091,13092,13093,13094,13161,13162,13163,13164,13168,13169,13170,13171,13476,13483,13968,14293,14295,14305,14315,14326,14329,14331,14335,14338,14339,14347,14350,14357,14367,14368,14369,14372,14402,14410,14411,14441,14442,14443,14469,14547,14632,14633,14634,14635,14636,14695,14696,14697,14698,14699,14700,14701,14703,14706,14734,14742,14887,14892,15005,15097,15377,15548,15800,15801,15872,15873,15879,15931,16057,16146,16281,16358,16373,16409,16410,16422,16425,16439,16440,16494,16497,16499,16503,16508,29933,17128,17130,17148,17153,17155,17159,17163,17168,17171,17176,17179,17184,17185,17218,17224,17299,17302,17352,17354,17355,17423,17449,17450,17451,17452,17455,17466,17470,17474,17478,17480,17492,17496,17499,17510,17536,17663,17679,17680,17681,17695,17699,17702,17703,17704,17780,17781,17783,17801,17812,17828,17834,17835,17836,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,18296,18297,18435,18436,18440,18441,18587,18602,18620,18641,18650,18651,18658,18659,18661,18662,18666,18667,18668,18681,18693,18731,18753,18944,18964,19180,19182,19184,19186,19187,19193,19200,19203,19204,19233,19236,19240,19241,19246,19247,19255,19257,19264,19290,19291,19297,19298,19301,19303,19304,19305,19335,19349,19380,19381,19383,19387,19391,19408,19409,19410,19412,19413,19415,19420,19423,19425,19427,19429,19486,19499,19500,19632,19645,19675,19681,19684,19750,19752,19755,19758,19922,19924,19929,19951,19968,20038,20050,20096,20099,20102,20220,20224,20227,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,20518,20519,20520,20521,20522,20523,20525,20526,20572,20573,20574,20575,20578,20579,20580,20739,20742,20752,20755,20770,20771,20772,20773,20774,20775,20790,20793,20796,20798,20799,20808,20809,20833,20834,20835,20901,20924,20953,20954,20955,20956,20958,20959,20961,20962,20963,20964,20985,20986,20987,21003,21004,21005,21008,21017,21034,21057,21066,21075,21078,21079,21096,21097,21110,21111,21118,21121,21131,21132,21166,21171,21180,21201,21202,21203,21223,21224,21225,21227,21228,21229,21259,21260,21261,21262,21263,21264,21265,21284,21289,21290,21320,21444,21445,21446,21447,21448,21449,21450,21451,21452,21471,21472,21473,21474,21486,21488,21489,21501,21502,21507,21509,21511,21512,21518,21519,21522,21523,21535,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,21828,21830,21880,22050,22057,22072,22073,22075,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,22127,22131,22137,22159,22160,22491,22492,22554,22555,22556,22557,22947,23052,23060,23066,23082,23085,23088,23109,23110,23117,23125,23126,23210,23211,23212,23213,23214,23215,23220,23221,23222,23223,23224,23226,23227,23229,23230,23278,23305,23329,23346,23880,23888,24024,24078,24085,25042,25043,25044,25045,25046,25047,25048,25049,25150,25151,25170,25172,25174,25253,25384,25385,25386,25387,25388,25389,25390,25391,25414,25418,25420,25433,25436,25441,25469,25515,25606,25677,25678,25688,25689,25723,25725,25735,25737,25743,25753,25754,25755,25758,26764,26816,26850,26880,27162,27181,27224,27226,27234,27256,27271,27272,28046,28074,28143,28145,28146,28295,28301,28361,28368,28367,28370,28375,28377,28378,28383,28385,28386,28396,28441,28448,28447,28450,28451,28452,28455,28456,28458,28459,28460,28463,28462,28464,28466,28467,28468,28469,28470,28482,28483,28487,28496,28497,28498,28499,28546,28547,28548,28549,29086,29145,29561,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,30195,30198,30203,30202,30226,30235,30239,30243,30255,30285,30286,30306,30318,30321,30324,30516,30517,30518,30521,30529,30530,30532,30533,30535,30539,30543,30546,30554,30555,30556,30560,30565,30569,30572,30573,30574,30577,30580,30582,30627,30644,30810,30862,30874,30882,30883,30890,31003,31006,31009,31012,18754,31190,31191,31194,31231,31230,31237,31238,31246,31245,31258,31269,31334,31362,31443,31444,31445,31446,31447,31448,31449,31450,31451,31452,31453,31454,31455,31456,31457,31458,31459,31460,46732,39563,32454,32455,32456,32457,32480,32481,32482,32483,32484,32524,32525,32526,32606,32607,33089,33090,33127,33130,33138,33137,33139,33140,33141,33257,33259,33270,33294,33307,33310,33317,33318,33348,33354,33355,33368,33369,33370,33371,41376,33763,34020,34039,34047,34085,34084,34086,34115,34119,34123,34211,34535,34715,34735,34736,34737,34738,35032,35043,35044,35130,35140,35159,35184,35209,35396,35399,35402,35405,35407,35411,35413,35416,35420,35618,35655,35656,35657,35658,35659,35660,48203,36093,36174,36186,36195,36277,36280,36283,36284,36291,36300,36303,36310,36315,36318,36321,36324,36338,36519,36520,36521,36528,36529,36530,36698,36709,36710,36862,36863,36864,36876,37006,37008,37030,37031,37032,37042,37043,37044,37053,37054,37055,37058,37061,37065,37066,37069,37070,37154,37153,37159,49037,49038,37254,37258,37266,37381,37395,37399,37400,37418,37419,37514,37516,37520,37542,37543,37544,37545,37546,37547,37548,37549,37550,37551,37552,37583,37590,38993,38994,41462,41461,39645,39818,39819,39820,39821,39828,39829,39852,39853,39858,39859,39862,39887,39890,39960,39961,40012,40016,40040,40230,40232,40233,48637,40652,40653,40654,40655,40676,40677,40678,40679,40704,40705,40706,40707,40708,40709,40710,40711,40712,40714,40774,40773,40776,40778,40791,40793,40862,40868,40871,40872,40874,40879,40880,40881,40883,40885,40887,40888,40895,40891,40901,40902,40911,40909,40913,40914,40918,40922,40924,40925,40929,40934,40941,40953,41000,41004,41006,41008,41009,41359,41363,41102,41103,41106,41109,41176,41177,41178,41179,41180,41181,41249,41298,41299,41300,41301,41323,41326,41325,41328,41329,41330,41416,41417,41419,41420,41422,41423,41424,41425,41426,41427,41428,41429,41430,41431,41432,41433,41434,41435,41455,41456,41457,41458,41604,41460,41475,41476,41478,41480,41481,41482,41488,41490,41494,41493,41500,41503,41508,41509,41510,41511,41512,41513,41534,41537,41538,41545,41547,41548,41559,41560,41561,41562,41563,41564,41566,41567,41568,41580,41581,41603,41726,41727,41728,41737,41738,41739,41740,41741,41742,41743,41744,41745,41759,41760,41761,41762,41957,41961,41965,42085,42086,42115,42362,42363,42364,42365,42366,42367,42440,42441,42442,42465,42466,42636,42671,42821,46722,43036,43039,43045,43046,43047,43048,43049,43199,43201,43202,44613,44615,43218,43219,43220,43221,43224,43314,43315,43316,43317,43318,43320,43322,43325,43329,43330,43335,43360,43361,43362,43363,43372,44710,43676,43677,43803,43805,43811,43812,43842,43843,43844,43845,43846,43847,43848,43849,43850,43851,43852,43853,43854,43855,43856,43858,43859,43860,43861,43862,43863,43864,43865,43866,43877,43878,43879,44046,44057,44060,44063,44066,44069,44070,44071,44072,44073,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,44563,44566,44567,44574,44576,44578,44588,44610,44611,44633,44647,44662,44703,44712,44713,44744,44925,44946,44954,44960,44967,44968,44969,44970,44971,43001,43002,12781,43015,43010,35507,44977,45002,45007,45043,45050,45065,45109,45142,45177,45192,45201,45223,45246,45247,45248,45249,45250,45251,45252,45253,45254,45255,45269,45584,45653,45658,45676,45677,45963,45966,45967,45968,46075,46098,46099,46106,46107,46116,46158,46161,46226,46231,46347,46350,46376,46212,46386,46527,46549,46550,46642,46643,46650,46651,46658,46663,46675,46676,46685,46687,46692,46698,46699,46700,46707,46708,46720,46723,46729,46730,46733,46731,46713,46696,46695,46694,46521,46740,46741,46742,46743,46744,46753,46754,46756,46758,46759,46848,46849,46853,46856,46854,46857,46855,46858,46859,46860,46861,46862,46863,46864,46865,46866,46867,46868,46869,46873,46954,46955,46956,46962,46970,47032,47039,47042,47051,47052,47053,47054,47104,47105,47227,47235,47251,47794,47795,47798,47801,47810,47812,47813,47819,47867,47871,47873,47879,47882,47884,47911,47912,48025,48026,48068,48069,48080,48084,48145,48153,48157,48160,48163,48208,48212,48213,48214,48215,48216,48217,48218,48253,48252,48254,48258,48259,48267,48294,48306,48304,48485,48504,48508,48514,48819,48818,48820,48821,48826,48827,48828,48829,48835,48836,48837,48842,48843,48909,48913,48914,49059,49060,49065,49066,49067,49068,49069,49070,49087,49136,49137,49398,49821,49835,49836,49837,49838,49839,49840,49841,49842,49847,49848,49849,50033,50036,50068,50070,50071,50079,50080,50179,50198,50213,50272,50273,50373,50374,50375,50376,50377,50378,50379,50380,50381,50382,50387,50412,50413,50414,50415,50424,50509,50533,50540,50703,50704,50708,50711,50893,50894,50977,50978,50998,50999,51000,51001,51002,51003,51004,51005,51013,51014,51016,51020,51019,51021,51045,51048,51117,51136,51196,51197,51198,51199,51200,51201,51202,51203,51204,51205,51206,51207,51208,51217,51218,51219,51220,51233,51234,51235,51238,51239,51240,51244,51245,51250,51249,51251,51252,51253,51254,51255,51256,51257,51258,51269,51285)) OR (categoryID IN (610)) ) AND ( enabled=1) AND status_off <> 1