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 (1296,1340,1522,1523,1551,5430,5431,5432,5433,5471,5480,5481,5482,5483,5492,5493,5494,5495,5496,5497,5498,5499,5500,5538,5539,5540,5548,6256,6258,11289,11290,11347,11469,11643,11889,11907,11910,11914,11917,11920,11932,11933,11934,11935,12249,12257,12540,12541,12542,12544,12545,12546,12555,12591,12594,12643,12644,12645,12646,12647,12648,12661,12662,12663,12664,12665,12666,12804,12805,12806,12807,12891,12892,12893,12928,12930,13548,14336,14337,14362,14363,14364,14404,14432,14433,14434,14435,14436,14437,14446,14448,14449,14455,14456,14515,14569,14570,14571,14572,14574,14576,14577,14825,14826,14888,15892,15899,15933,16081,16082,16144,16149,16368,16398,16438,16443,16444,16445,16457,16458,16522,16523,16524,16525,16535,16539,16548,16550,16604,16606,16781,16782,16783,16784,18694,18700,18742,18795,18796,18797,18799,18806,18918,18954,18957,18959,18960,19706,19721,19722,20249,20259,20261,20385,20454,20455,20456,20457,20458,20461,20462,20464,20716,20717,20718,49040,20988,20989,20990,20991,20992,20993,21028,21029,21030,24466,21299,21300,21301,21307,21308,21309,21310,21311,21312,21313,21314,21318,21319,21403,21405,21410,21412,21413,21414,21419,21421,21422,21423,21424,21426,21427,21430,21431,21435,21436,21438,21439,21440,21441,21453,21454,21455,21456,21457,21458,21459,21460,21461,21462,21463,21464,21465,21466,21467,21468,21469,21470,21478,21479,21481,21482,21483,21528,21529,21590,21826,22139,22923,23103,23104,23188,23189,30056,23815,23816,24962,25027,48940,26548,26549,26603,26605,26607,26770,26771,26840,27217,27218,49039,27901,27900,27899,27902,27903,27906,27907,27908,28064,29210,29211,29212,29213,34876,29410,29523,29524,29525,29526,29532,29533,29534,29535,29536,29620,29624,29667,29668,29669,29670,29977,29978,48934,48938,30046,31052,31064,31065,31066,31154,31155,31156,31157,31164,31170,31171,31987,32265,32266,32267,34879,34871,34870,34877,34872,32465,32466,32467,32468,32469,32470,32471,32472,32473,34878,34880,34881,34873,34874,34875,33783,33784,33785,33786,34087,34088,34122,34290,34292,34293,34299,34303,34304,34309,34323,34326,34741,34742,34743,34758,34759,34760,34761,34763,34764,34765,34766,34805,34827,34828,34829,34830,34831,34833,34838,34839,48939,34865,34866,34867,34868,34869,34922,34923,34924,34925,34926,34927,34928,34929,34930,35306,35305,35304,35352,35355,35423,35424,35425,35426,35427,35428,35429,35430,35431,35432,35447,35445,35492,35493,36524,36533,36868,36872,36878,37299,37483,37522,37525,37526,37529,47713,41279,39116,39119,39317,39464,39465,39537,39571,39572,39576,39577,39578,39622,39621,39627,39628,39632,39631,39633,39635,39636,39638,39642,39641,39640,39643,39740,39749,39834,39835,39836,39837,40006,40007,40008,40009,40010,40011,40022,40241,40244,40243,40245,40272,40273,40274,40275,40278,40277,40276,40279,40280,40322,40321,40323,40325,40326,40341,40354,40355,40357,40356,40358,40359,40361,40360,40362,40366,40365,40367,40368,40393,40394,40432,40441,40442,40461,40464,40465,40466,40467,40468,40469,40470,48627,48626,48613,41280,40647,40996,40997,41069,41072,41074,41076,41077,41078,42095,42385,42386,42408,42409,43035,43393,43397,43443,43484,43488,43504,43510,43514,43515,43516,43610,43613,43614,44194,44195,44196,44307,44308,44309,44310,44311,44312,44423,44490,44491,44492,44494,44495,44496,44497,44498,44499,44500,44913,44995,44998,45000,45003,45004,45008,45010,45014,45015,45016,45017,45028,45029,45035,45217,45218,45222,45224,45225,45387,45971,46162,46678,46679,46702,46703,46709,46710,46714,46715,46721,46724,46725,46745,46748,46852,46952,46953,47057,47106,47187,47188,47189,47190,47191,47192,47202,47203,47206,47208,47210,47209,47743,47755,47756,47757,47758,47770,47769,47891,47892,47909,47910,48045,48046,48226,48228,48240,48248,48249,48260,48261,48264,48329,48330,48337,48338,48341,48342,48343,48344,48353,48354,48355,48356,48357,48358,48919,48932,49041,49042,49084,49085,50420,50421,50422,50423,50526,50534,50535,50536,50629,50631,50661,50662,50666,50667,50697,50698,50699,50700,50701,50702,50705,50707,50783,50785,50871,50873,50886,50887)) OR (categoryID IN (759)) ) AND ( enabled=1) AND status_off <> 1