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 (697,701,704,708,715,716,717,718,719,732,733,734,735,736,737,743,744,745,746,796,800,804,807,812,822,823,827,859,861,862,867,926,931,934,937,943,949,978,979,980,1104,1108,1122,1129,1130,1131,1132,1136,1137,1147,1148,1149,1150,1151,1152,1307,1311,1315,1316,1328,1329,1550,1803,1804,1865,1866,1869,1873,1874,1880,1889,1894,1896,1917,1921,1927,2026,2027,2348,2354,2365,2368,2378,2485,2490,2527,2528,2534,2535,2544,2547,2571,2572,2831,2832,2839,2842,2843,2862,2868,2878,2923,2941,2954,2964,2965,2982,2991,2995,3005,3027,3039,3040,3042,3052,3058,3065,3093,3100,3104,3105,3109,3110,3125,3126,3132,3188,3189,3193,3194,3198,3204,3212,3215,3220,3223,3224,3370,3391,3427,3428,3436,3454,3455,3458,3464,3467,3478,3485,3487,3491,3510,3513,3564,3596,3774,3775,3776,3777,3848,4076,4102,4145,4148,4152,4153,4175,4210,4232,4234,4238,4243,4252,4253,4256,4364,4379,4382,4386,4391,4395,4401,4403,4417,4419,4425,4690,5009,5065,5092,5113,5118,5133,5150,5338,5339,5354,5385,5406,5434,5435,5436,5437,5446,5451,5458,5473,5476,5524,5525,5552,5567,5568,5692,5693,5729,5730,5744,5747,5748,5749,5756,5837,5961,5963,5964,5979,5988,6194,6207,6210,6214,6222,6243,6246,6251,6254,6255,6265,6268,6271,6275,6282,6285,6286,6292,6412,6454,6754,6755,6783,6788,6789,6797,6798,6799,6816,6817,6818,6825,6826,6827,6834,6835,6836,6840,6844,6845,6859,6860,6861,6866,6867,6878,6879,6884,6887,6892,6893,6894,6895,6896,6897,6898,6899,6916,6919,6926,6927,6936,6937,6949,6984,7013,7014,7015,7047,7125,7126,7147,7148,7149,7174,7190,7191,7198,7209,7210,7241,7390,7508,7509,7592,7607,7725,7726,7727,7769,7784,7799,7800,8378,8436,8437,9501,9502,9506,9507,9671,9773,9836,10383,10801,10839,10840,10908,10909,10912,10913,10928,10938,11456,11458,11460,11468,11492,11505,11506,11519,11520,11521,11522,11558,11559,11560,11561,11610,11612,11747,11748,11833,11870,11871,11872,11873,11874,11875,11876,11877,12000,12029,12049,12055,12062,12222,12230,12235,12245,12318,12324,12466,12475,12496,12509,12516,12535,12679,12787,12885,12900,12901,13161,13162,13163,13164,14268,14315,14325,14331,14335,14347,14367,14384,14391,14410,14441,14442,14460,14464,14527,14528,14539,14544,14547,14625,14813,14818,14819,14828,14907,15108,15205,15449,15452,15458,15471,15498,15610,15901,15905,16183,16186,16271,16274,16277,16281,17138,17143,17147,17420,17455,17510,17536,17551,17597,17599,17687,17690,17693,17695,17699,17834,17835,17836,17896,17897,17898,18004,18005,18007,18014,18015,18233,18235,19180,19182,19184,19200,19203,19204,19292,19293,19294,19295,19610,19656,19664,19714,19761,19924,19989,20909,20924,21041,21057,21062,21063,21064,21131,21132,21166,21171,42117,21226,21230,21293,21296,21494,21779,21797,21799,21800,21816,21820,21827,21838,21880,22048,22714,23082,23085,23166,23171,23235,23278,23305,23346,23427,23465,23469,23470,23476,23480,23481,23785,23828,23872,23880,23883,23888,24024,24078,24085,24134,24147,24148,24179,24389,24473,24532,24627,24643,24668,24681,24686,24690,24809,25060,25062,25143,25163,25165,42990,25721,26291,26292,26354,26399,26406,26420,26425,26433,26530,26528,26578,26835,26839,26879,27044,27106,27108,27296,27305,27327,27929,27951,28031,28043,28046,28107,28122,28126,28559,28597,28612,29452,29488,29489,29511,29512,29513,29514,29568,29571,29583,29582,29585,29584,29612,29613,30698,30870,30882,30883,30890,30898,30899,31135,31133,31132,31160,31334,31383,31388,31394,31397,31406,31412,31422,31427,31937,32606,32607,32618,32621,32633,32663,32676,32675,32689,32690,32775,32776,32783,32969,32970,33005,33040,33055,33060,33062,33066,33069,33186,33205,33481,33482,33478,33554,33557,33562,33570,33571,33740,33855,33863,33871,33940,34126,41662,34492,34715,35499,35594,35628,36007,36009,36297,36335,37154,37159,37254,37258,37378,37408,37486,37487,37488,38961,38964,38957,38958,38864,38865,38880,38881,39067,38967,43000,39004,39025,39026,39030,39031,39036,39037,39041,39044,39045,39050,39049,39309,41971,39350,39353,39517,39611,39810,39944,40918,40925,40953,40981,41560,41978,42038,42084,42282,42283,42362,42363,42364,42365,42366,42367,42456,42461,42600,42627,42675,42765,42768,43061,43060,43077,43082,43085,43332,43425,43489,43499,43500,43503,43583,43664,43665,43676,43677,43707,43717,43721,43811,43812,43830,43832,44554,44555,44560,44563,44566,44567,44571,44574,44610,44611,44633,44647,44662,44954,44957,44960,45065,45069,45099,45098,45114,45226,45240,45412,45472,45679,46658,46663,46863,46864,46865,46866,46867,46868,46869,46954,46955,46956,47084,47118,47270,47271,47276,47288,47291,47295,47301,47303,47314,47315,47320,47341,47352,47359,47365,47369,47372,47375,47378,47387,47390,47393,47408,47411,47414,47419,47422,47426,47429,47433,47454,47458,47515,48266,48318,48479,49091,49096,49142,49144,49157,49168,49169,49170,49473,49898,49895,49901,49905,49906,49909,49911,49912,49917,49918,49921,49922,49926,49927,49932,50033,50036,50476,50479,50665,50669,50673,50675,50716,50717,50718,50721,50880)) OR (categoryID IN (605)) ) AND ( enabled=1) AND status_off <> 1