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 (1107,1179,1180,1181,1345,1360,1514,1563,1564,1565,1597,1598,1599,1600,1604,1778,1781,1787,1789,1790,1791,1792,1796,1797,1798,1799,1821,1980,2036,2038,2436,2893,2921,3416,3524,3525,3526,3751,3752,3754,3755,3767,3768,3769,3770,3771,3778,3779,3782,3783,3794,3797,3798,3799,3801,3802,3808,3809,3811,3813,3814,3815,3816,3818,3819,3820,3823,3824,3825,3855,3856,3857,3859,3861,3870,3871,3890,3906,3907,3911,3970,3974,3975,3989,3990,3999,4000,4001,4004,4005,4012,4062,4063,4066,4067,4077,4078,4081,4082,4085,4086,4089,4090,4092,4093,4100,4101,4104,4136,4137,4167,4168,4318,4323,4327,4331,4332,4334,4337,4348,4363,4369,4370,4373,4442,4443,4444,4528,4537,4549,4550,4556,4557,4558,4580,4581,4583,4584,4587,4588,4641,4642,4645,4646,4658,4659,4660,4661,4666,4667,4668,4670,4671,4673,4674,4723,4724,4725,4726,5014,5017,5019,5023,5024,5026,5027,5028,5029,5030,5055,5056,5058,5059,5070,5071,5076,5078,5080,5081,5085,5086,5088,5121,5123,5136,5153,5154,5155,5156,5157,5170,5178,5179,5182,5183,5184,5195,5196,5198,5199,5202,5203,5204,5207,5208,5209,5210,5211,5212,5215,5216,5217,5218,5221,5224,5225,5325,5328,5428,5448,5477,5572,5574,5580,5594,5595,5599,5650,5651,5652,5655,5656,5661,5662,5803,5804,5805,5806,5807,5808,5811,5812,5813,5814,5816,5817,5818,5819,5820,5827,5828,5829,5831,5968,5969,5970,5971,5972,5973,6354,6356,6366,6401,6440,6455,6456,6463,6464,6747,6751,6752,6972,6973,6979,6980,7037,7039,7133,7134,7135,7136,7138,7139,7145,7192,7193,7196,7264,7282,7309,7346,7364,7381,7952,7978,8331,8332,8369,10782,10783,10785,11413,11414,11415,11767,11769,11787,11788,11800,11802,11803,11805,11806,11808,11809,11814,11817,11818,11820,11821,11822,11829,11830,11838,11839,11841,11842,11845,11846,11847,11848,11885,11886,11887,11888,11891,11892,11895,11896,11898,11899,11901,11902,11903,11905,11909,11918,11919,11922,11923,11924,11925,11926,11928,11929,11930,12021,12022,12023,12026,12027,12042,12043,12066,12067,12068,12076,12085,12088,12098,12122,12123,12124,12127,12128,12129,12131,12132,12133,12281,12322,12323,12325,12326,12447,12448,12450,12456,12464,12465,12467,12468,12476,12477,12478,12491,12492,12499,12500,12501,12503,12507,12508,12514,12515,12519,12521,12530,12531,12556,12558,12564,12565,12567,12568,12572,12581,12582,12583,12585,12764,12766,12768,12889,12902,12903,12905,12906,12907,12908,13253,13255,13256,13269,13270,13271,13272,13277,13278,13291,13292,13293,13294,13298,13318,13322,13327,13331,13343,13344,13345,13349,13351,13352,13358,13359,13360,13364,13365,13368,13369,13377,13378,13379,13380,13385,13389,13390,13393,13396,13402,13403,13405,13409,13410,13411,13416,13417,13418,13419,13422,13424,13425,13429,13432,13433,13435,13436,13439,13440,13442,13444,13445,13446,13449,13450,13454,13455,13456,13460,13462,13468,13469,13470,13473,13475,13485,13491,13493,13497,13502,13503,13504,13505,13509,13510,13516,13519,13524,13527,13528,13532,13533,13535,13536,13538,13539,13549,13550,13551,13553,13559,13563,13565,13566,13569,13572,13574,13576,13577,13580,13584,13585,13586,13587,14245,14250,14270,14273,14461,14463,14477,14479,14485,14486,14488,14489,14518,14519,14566,14568,14586,14587,14588,14589,14591,14592,14593,14596,14606,14609,14611,14613,14614,14615,14795,14797,14802,14808,14844,14918,14923,14924,15014,15017,15065,15073,15075,15079,15081,15082,15086,15087,15090,15092,15119,15121,15122,15124,15125,15130,15131,15132,15153,15155,15158,15159,15163,15164,15167,15183,15184,15185,15187,15188,15197,15206,15207,15210,15211,15222,15223,15227,15379,15380,15387,15388,15389,15535,15536,15538,15578,15579,16163,16165,16174,16175,16200,16201,16203,16205,16210,16217,16221,16254,16286,16287,16391,16392,16455,16456,34451,16792,16837,16838,16839,16931,16932,16935,17261,17464,17469,17577,17579,17607,17609,17611,18404,18405,18934,18935,19082,19084,19092,19678,19679,19732,19733,19734,19861,19862,19868,19914,19915,19946,19947,19990,19991,19992,19994,19995,19996,21052,21053,21054,21055,21234,21235,21243,21245,21274,21275,21276,21278,21280,21412,22930,22931,22935,22941,22942,22980,22986,22987,22997,23004,23008,23013,23015,23016,23025,23026,23070,23089,23090,23092,23093,23094,23096,23097,23459,23472,23473,23474,23478,23489,23490,23491,23494,23495,23528,23529,23530,23700,23702,23703,23711,23712,23725,23726,23751,23752,23757,23758,23761,23762,23763,23764,23767,23768,23793,23938,23939,23941,23942,23946,23947,23952,23953,24061,24064,24066,24068,24069,24125,24128,24129,24130,24132,24133,24135,24136,24141,24142,24143,24144,24162,24166,24169,24171,24209,24210,24229,24230,24231,24232,24391,24392,24404,24405,24474,24475,24483,24494,24488,24497,24544,24545,24653,24662,24683,24694,24693,24695,24696,24697,24698,24701,24702,24713,24714,24715,24721,24722,24727,24729,24731,24733,24735,24736,24738,24743,24772,24779,24782,24802,14917,25064,25065,25099,25720,26286,26285,26302,26303,26335,26344,26345,26377,26398,26576,26585,26586,26593,26595,26607,26834,26836,26838,26958,26997,27042,27046,27114,27115,27117,27118,27223,27233,27287,27323,27325,27361,27909,27910,27911,27923,27924,27925,27926,27959,27955,27960,27958,27957,27994,27995,27996,27998,27999,28008,28009,28014,28013,28032,28034,28036,28037,28049,28050,28064,28071,28082,28083,28092,28119,28120,28123,28124,28127,28128,28207,28208,28265,28281,28282,28284,28285,28598,28599,28605,28608,28610,28611,28956,28957,28991,28993,29054,29055,29063,29064,29159,29332,29441,29442,29446,29540,29597,29599,30575,30576,30581,30585,30590,30591,30594,30601,30602,30607,30608,30611,30614,30615,30625,30626,30629,30628,30634,30707,30708,30711,30716,30718,30719,30722,30728,30729,30734,30735,30748,30749,30750,30755,30757,30758,30759,30762,30770,30772,30776,30781,30784,30787,30788,30791,30792,30800,30803,30806,30825,30829,30834,30840,30841,30852,31219,31222,31225,31278,31279,31286,31287,31290,31291,31311,31312,31313,31316,31317,31327,31326,31339,31338,31345,31346,31347,31350,31351,31352,31367,31380,31410,31411,31415,31416,31417,31419,31420,31553,31554,31555,31880,31881,31882,31924,32232,32237,32238,32239,32241,32242,32243,32249,32256,32252,32253,32254,32250,32257,32258,32259,32260,32609,32612,32615,32624,32625,32626,32627,32628,32644,32645,32646,32647,32649,32655,32656,32695,32736,32741,32743,32744,32745,33207,33254,33552,33553,33576,33578,33579,33582,33583,33585,33586,33590,33594,33597,33598,33601,33602,33604,33605,33607,33609,33610,33613,33615,33646,33652,33653,33654,33757,33758,33760,33769,33775,33776,33909,33915,33916,33933,33936,12590,12593,33941,33942,33963,33964,33966,33971,34007,34008,34444,34508,34510,34513,34554,34555,34680,34713,34714,35277,35169,35170,35172,35176,35187,35189,35190,35200,35203,35204,35214,35216,35217,35219,35221,35222,35224,35225,35236,35237,35241,35243,35262,46065,35414,47686,35500,35501,35502,35503,35504,35505,35509,35510,35511,35585,35586,35595,35604,35608,35609,35610,35622,35623,35624,35625,35632,35633,35634,35821,35822,35824,35825,35827,35828,35831,35832,35834,35835,35837,35838,35845,35844,35852,35853,35874,35875,35876,35878,35880,35881,35883,35884,35886,35890,35887,35888,35893,35894,35895,35896,35977,35978,35980,35986,36012,36014,36018,36027,36030,36031,36044,36046,36056,36057,47687,36389,36390,36404,36465,37285,37286,37296,37297,37299,37301,37302,37303,37363,37364,37415,37416,37417,37598,37599,37600,37601,37611,37612,37613,37614,37615,37616,37617,37618,37619,37620,37621,37622,37629,37630,37633,37634,37635,37642,37643,37644,37645,37646,37647,37648,37649,37650,37651,37652,37653,37654,37657,37658,37663,37664,37665,37666,37667,37668,37669,37670,37671,37678,37679,37680,37681,37682,37683,37684,37685,37686,37687,37852,37853,37854,38025,38028,38029,47674,47673,47629,47675,38956,38955,39089,39113,39112,39115,39114,39119,39122,39088,38836,38837,38840,38841,38843,38844,38846,38848,38861,38862,39023,39024,39123,39163,39166,39169,39171,39177,39178,39188,39189,39190,39441,39442,39463,39466,39476,39482,39483,39487,39515,39588,39589,39609,39610,39612,39639,39772,39774,40988,40989,40997,40996,42108,42109,42110,43348,43354,43498,43505,43506,43516,43517,43563,43568,43571,43584,43605,43615,43616,43617,43619,43623,43631,43632,43638,43639,45771,45772,45774,45775,46454,46455,46488,46489,46490,46493,46494,46497,46498,46500,46501,46502,47242,47243,47244,47245,47246,47272,47274,47285,47287,47346,47347,47348,47350,47351,47354,47355,47356,47357,47370,47371,47373,47374,47379,47380,47382,47383,47388,47389,47391,47392,47412,47413,47416,47427,47428,47480,47481,47482,47484,47487,47723,47724,47760,47761,47763,48243,48245,48414,49163,49164,49165,49182,49193,49545,49546,49647,50174,50175,50176,50282,50288,50289,50290,50292,50291,50293,50493,50494)) OR (categoryID IN (687)) ) AND ( enabled=1) AND status_off <> 1