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 (6883,6886,6905,6910,6911,6913,14847,15118,15315,15322,15746,15754,16164,18541,18550,20666,20674,20676,20680,20690,20692,20696,20697,20700,20701,20704,20706,20707,20708,20709,20800,20801,20802,20803,20851,20854,22598,22601,22603,22605,22610,22778,22780,22783,22785,24127,24151,24154,24159,24161,24163,24164,24165,24194,24196,24197,24205,24206,24207,24225,24271,24272,24273,24274,24275,24276,24277,24278,24280,24292,24293,24294,24295,24296,24297,24298,24299,24301,24304,24307,24312,24313,24314,24315,24320,24888,24887,24890,25164,25173,25175,25176,25177,25238,25239,25240,25241,25242,25243,25244,25246,25245,25247,26334,26337,26340,26339,41531,31923,31925,31926,31927,32046,32049,32050,32052,32053,32054,32057,32059,32060,32063,34253,34265,34267,34272,34275,41532,41530,34744,34746,42831,36170,36171,36172,36176,36177,41529,42755,42756,42758,42759,42761,42762,42770,42771,42773,42774,42777,42776,42778,42780,42779,42781,42782,42783,42792,42793,42794,42795,42799,42825,42818,42837,42840,42847,42891,42887,42886,42883,42868,42893,42889,42894,42896,42897,42899,42900,42902,42904,42905,42906,43637,43646,43647,43648,43651,43652,43653,43655,43656,43667,43668,43680,43681,43683,43685,43686,43688,43689,43691,43710,43711,43712,43714,43733,43739,43740,43742,43745,43750,43748,43749,43887,43901,43903,43908,43914,44326,44327,44329,44334,44333,44339,44341,44345,44346,44348,42815,42809,49620,44741,44742,44743,44764,44765,44766,44773,44802,44812,44817,44818,44822,44836,44846,44848,44854,44860,44867,44891,44895,49268,49269,49272,49273,49275,49305,49306,49308,49312,49314,49341,49342,49343,49344,49345,49346,49354,49355,49356,49357,49358,49423,49431,49436,49442,49451,49456,49459,49469,49482,49481,49483,49484,49551,49552,49553,49555,49554,49556,49562,49565,49566,49568,49569,49576,49577,49579,49581,49583,49588,49587,49591,49593,49596,49595,49598,49600,49607,49608,49616,49618,49619,49621,49622,49623,49628,49627,49629,49633,49635,49636,49638,49637,49640,49643,49644,49684,49725,49727,49730,49732,49734,49736,49738,49741,49747,49748,49749,49750,49751,49753,49752,49754,49755,49756,49757,49817,49819,49820,49822,49854,49856,49859,49861,49868,49875,49880,49884,49963,49965,49970,49972,49977,49979,49983,49985,49989,49992,49995,50001,50003,50011,50013,50018,50014,50016,50015,50022,50028,50025,50043,50046,50045,50049,50051,50050,50053,50054,50055,50057,50058,50061,50062,50063,50065,50066,50067,50069,50072,50073,50074,50076,50078,50296,50305,50311,50309,50313,50317,50322,50327,50339,50341,50342,50345,50388,50391,50393,50395,50396,50398,50401,50403,50404,50406,50409,50434,50433,50436,50439,50441,50442,50444,50446,50448,50451,50453,50454,50456,50458,50460,51018,51007,51009,51011,51025,51033,51071,51073,51075,51077,51079,51081,51083,51085,51088,51089,51146,51154,51155,51159,51160,51161,51165,51166,51170,51172,51175,51176,51179,51185,51183,51182,51186,51189,51190,51192,51195)) OR (categoryID IN (767)) ) AND ( enabled=1) AND status_off <> 1