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 (695,696,699,700,706,707,711,712,713,714,722,723,738,739,740,795,798,801,803,805,806,808,809,810,813,815,819,820,824,826,832,865,866,874,876,877,923,924,925,929,930,932,933,935,936,941,942,947,948,970,971,972,973,974,975,976,977,1103,1109,1121,1124,1127,1133,1134,1135,1153,1157,1255,1256,1259,1275,1276,1318,1319,1320,1324,1325,1541,1542,1543,1544,1545,1548,1677,1802,1805,1806,1863,1864,1867,1868,1871,1872,1878,1879,1886,1887,1888,1892,1893,1895,1916,1918,1919,1920,1924,1925,1926,2024,2025,2031,2141,2356,2358,2360,2380,2381,2401,2404,2409,2411,2419,2494,2525,2526,2531,2532,2533,2542,2543,2545,2546,2552,2556,2578,2814,2826,2841,2848,2857,2858,2859,2877,2879,2917,2919,2921,2935,2952,2953,2961,2970,2971,2972,2985,2986,2987,2988,2989,2990,3002,3003,3004,3021,3026,3053,3054,3055,3060,3062,3063,3064,3067,3068,3069,3081,3083,3084,3091,3092,3097,3098,3099,3108,3120,3121,3122,3127,3128,3200,3201,3202,3203,3208,3209,3211,3213,3214,3216,3217,3365,3366,3369,3389,3390,3396,3401,3425,3426,3434,3435,3448,3449,3450,3451,3452,3453,3456,3457,3462,3463,3465,3466,3468,3469,3470,3471,3472,3473,3474,3475,3476,3477,3482,3483,3484,3486,3489,3490,3492,3493,3508,3509,3511,3512,3531,3553,3563,3595,3597,3598,4075,4100,4101,4133,4134,4142,4143,4144,4146,4147,4149,4150,4151,4170,4226,4233,4235,4236,4237,4251,4254,4255,4304,4305,4363,4375,4376,4377,4378,4380,4381,4384,4385,4388,4389,4390,4392,4393,4394,4396,4397,4398,4399,4400,4402,4418,4420,4421,4424,4688,5007,5008,5015,5036,5049,5051,5062,5064,5090,5091,5093,5096,5109,5111,5114,5116,5131,5132,5151,5152,5170,5340,5341,5342,5347,5348,5402,5405,5443,5447,5449,5450,5452,5453,5456,5459,5461,5462,5463,5464,5467,5468,5470,5474,5475,5484,5485,5486,5487,5488,5489,5490,5491,5503,5504,5505,5506,5507,5508,5513,5514,5515,5520,5521,5522,5523,5550,5551,5563,5564,5565,5566,5590,5591,5690,5691,5727,5728,5731,5742,5743,5745,5746,5750,5751,5752,5753,5754,5755,5757,5758,5760,5794,5795,5836,5928,5929,5945,5982,5991,6190,6191,6192,6193,6195,6204,6205,6206,6208,6209,6215,6216,6217,6223,6224,6225,6240,6263,6264,6266,6267,6269,6270,6276,6277,6283,6284,6287,6288,6289,6290,6291,6297,6298,6299,6300,6301,6328,6405,6409,6436,6450,6451,6740,6744,6748,6749,6750,6753,6837,6841,6842,6843,6903,6904,6922,6924,6944,6947,6948,6979,6980,6996,6997,6998,7000,7001,7002,7005,7007,7009,7012,7019,7034,7040,7052,7054,7090,7097,7100,7104,7110,7129,7130,7131,7132,7133,7135,7136,7137,7139,7140,7146,7154,7158,7159,7164,7179,7180,7182,7184,7185,7186,7187,7188,7194,7195,7197,7199,7200,7202,7203,7204,7230,7236,7237,7240,7258,7260,7310,7328,7402,7445,7452,7469,7524,7525,7526,7555,7567,7581,7667,7668,7669,7670,7671,7672,7678,7723,7724,7766,7767,7768,7779,7780,7781,7794,7795,7796,7798,7808,8389,8431,8433,9241,9245,9246,9249,9251,9498,9769,9770,9771,10377,10381,10382,10784,10795,10796,10799,10800,10814,10820,10890,10907,10991,11088,11089,11442,11444,11454,11476,11478,11484,11490,11496,11497,11503,11509,11510,11511,11512,11515,11516,11538,11539,11540,11541,11542,11543,11544,11545,11562,11563,11564,11568,11570,11587,11588,11589,11600,11602,11604,11606,11746,11750,11831,11832,11895,11896,12026,12027,12046,12047,12059,12060,12219,12227,12231,12232,12233,12236,12237,12238,12240,12246,12296,12300,12311,12316,12317,12322,12323,12457,12464,12465,12470,12476,12477,12478,12479,12487,12494,12495,12503,12507,12508,12513,12514,12515,12533,12534,12677,12678,12763,12783,12785,12874,12875,12882,12883,12884,12896,12897,12898,12899,13381,13382,14267,14301,14312,14313,14314,14321,14322,14323,14332,14333,14334,14345,14346,14375,14376,14388,14407,14408,14462,14466,14472,14478,14490,14495,14524,14525,14526,14536,14537,14538,14540,14541,14545,14546,14557,14565,14567,14569,14576,14577,14618,14619,14621,14758,14759,14773,14811,14812,14814,14815,14816,14817,14821,14829,14889,14891,15104,15105,15128,15204,15450,15451,15453,15454,15455,15456,15457,15465,15467,15472,15474,15483,15484,15486,15487,15493,15494,15503,15521,15606,15609,15902,15906,16181,16182,16184,16185,16269,16270,16272,16273,16275,16276,17017,17145,17453,17507,17583,17584,17587,17589,17591,17593,18225,18794,18875,18891,19609,19654,19655,19662,19713,19777,19920,19921,19987,19988,20592,20593,20904,20905,20906,20907,20908,20928,20929,20968,20969,21037,21038,21051,21056,21059,21060,21061,21126,21127,21128,21129,21130,21142,21143,21150,21154,21155,21292,21294,21778,21809,21815,21818,21825,21826,22944,23081,23083,23084,23092,23096,23099,23139,23140,23141,23144,23145,23149,23161,23163,23173,23231,23232,23466,23467,23468,23477,23482,23483,23751,23752,23822,23877,23878,23884,23885,23891,24132,24133,24145,24146,24186,24187,24203,24208,24227,24228,24387,24388,24471,24472,24539,24542,24625,24626,24645,24649,24672,24674,24677,24684,24685,24691,24692,24810,25054,25056,25058,25059,25098,42996,25139,25142,25144,25145,25146,25147,25148,25152,25162,42997,42988,25720,26288,26289,26293,26294,26295,26296,26359,26364,26400,26401,26418,26419,26421,26422,26423,26424,26449,26450,26525,26526,26538,26543,26834,26836,26838,27046,27109,27299,27301,27313,27315,27329,27332,27928,27953,27973,28028,28030,28040,28072,28105,28106,28115,28116,28119,28120,28123,28124,28141,28289,28302,28568,28594,28595,28610,28611,28957,28956,29175,29209,29447,29449,29451,29481,29490,29491,29609,29610,29611,30497,30498,30503,30504,30519,30520,30540,30541,30558,30559,30566,30567,30814,30836,30838,30842,31276,31280,31281,31332,31333,31375,31389,31395,31396,31398,31399,31407,31408,31413,31414,31415,31416,31417,31423,31426,31428,31429,31430,32248,32506,32507,32508,32602,32603,32604,32605,32608,32611,32614,32630,32631,32632,32654,32685,32686,32687,32688,34885,32774,32777,32778,32784,32785,32790,32990,32995,32996,32997,33071,33072,33075,33076,33210,33483,33484,33480,33479,33555,33556,33558,33559,33560,33561,33563,33564,33574,33575,33580,33741,33742,33811,33812,33849,33850,33856,33857,33861,33862,33865,33870,33873,33874,33912,33913,33941,33942,34013,34014,34113,34114,34124,34125,34128,34129,34496,34498,35204,35506,35515,35590,35591,35595,35620,35629,35630,35631,35637,35639,35640,35642,35643,36008,36010,37161,37250,37251,37252,37255,37256,37257,37259,37260,37261,37379,37380,37394,37405,37409,37489,37490,37492,47338,38962,38963,42995,38965,38966,38959,38960,39081,39080,38970,38849,38856,38866,38867,38882,38883,38969,42987,39005,39006,39027,39028,39029,39032,39033,39034,39035,39038,39039,39040,39042,39043,39046,39047,39048,39051,39052,39053,39310,39312,39351,39352,39354,39520,39524,39609,39610,39612,39811,39812,39813,39939,39941,39940,39968,39974,40240,40954,40955,41972,41980,41975,41979,42118,42081,42082,42083,42119,42120,42121,42284,42286,42288,42290,42454,42455,42458,42467,42599,42622,42625,42633,42763,42764,42766,42767,42985,43032,43031,43044,43079,43080,43081,43083,43084,43339,43343,43426,43427,43490,43491,43584,43605,43615,43616,43617,43661,43662,43663,43678,43696,43699,43703,43704,43706,43806,43807,43808,43809,43810,44099,44101,44104,44105,44548,44549,44552,44553,44556,44557,44558,44561,44562,44564,44565,44568,44569,44572,44573,44591,44612,44636,44640,44648,44663,44679,44958,44959,45038,45049,45066,45067,45068,45072,45074,45101,45102,45228,45227,45229,45241,45242,45243,45244,45414,45417,45419,45438,45450,45458,45459,45475,45476,45511,45583,45680,46074,46659,46660,46661,46680,46810,47120,47121,47126,47262,47267,47265,47266,47269,47272,47274,47282,47277,47285,47287,47296,47297,47298,47300,47306,47307,47308,47311,47313,47316,47317,47318,47319,47350,47351,47354,47355,47367,47356,47357,47360,47361,47362,47368,47366,47370,47371,47373,47374,47376,47377,47379,47380,47388,47389,47391,47392,47394,47395,47409,47410,47412,47413,47416,47420,47421,47424,47425,47428,47427,47430,47431,47432,47434,47436,47519,47524,47529,49093,49094,49097,49098,49145,49147,49149,49151,49171,49173,49172,49178,49518,49494,49528,49799,49801,49899,49893,49900,49910,49915,49916,49920,49925,49934,49935,49937,49940,49942,49943,50008,50009,50010,50017,50019,50020,50021,50026,50030,50031,50032,50037,50038,50039,50429,50428,50477,50478,50480,50486,50490,50491,50500,50663,50664,50668,50670,50672,50674,50719,50720,50722,50723,50724,50877,50879,50881,50882)) OR (categoryID IN (577)) ) AND ( enabled=1) AND status_off <> 1