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 (6852,6883,6886,6905,6910,6911,6913,6938,6940,6941,6942,6943,6945,6946,6952,6953,6954,6955,6956,6957,6958,6959,6963,7733,7739,7740,7743,7747,7753,7756,7761,7762,7765,7770,7771,7772,7774,7775,7777,7778,7785,7786,7788,7789,7791,7797,7802,7803,7804,7805,7806,7925,7928,7981,7996,8000,9908,9913,9918,10286,10297,10299,10301,10303,10309,10318,11768,11777,11780,11784,11785,11979,11980,11981,11982,11983,11984,11985,11986,11987,12104,12105,12106,12107,12108,12110,12111,12112,12149,12150,12152,12154,12156,12157,12158,12159,14824,14830,14843,14911,14912,14913,14914,14946,14948,15112,15115,15298,15302,15303,15304,15307,15309,15310,15313,15314,15315,15319,15320,15322,15749,15752,15756,15757,15766,15770,15775,16177,16178,16187,16191,16193,16194,16196,16197,16323,16547,16555,16561,16567,16571,16663,16665,16667,16668,16669,16672,16681,16686,16687,16749,16754,16755,16841,16858,16936,16943,16947,16948,16953,16961,16967,16970,16974,16978,16979,18262,18265,18267,18270,18272,18274,18281,18285,18288,18291,18294,18323,18324,18325,18334,18335,18336,18347,18348,18461,18541,18546,18550,39065,18554,18597,18617,18950,18956,19067,19603,19620,20437,20439,20441,20443,20445,20656,20662,20666,20669,20671,20672,20674,20675,20676,20680,20682,20683,20684,20685,20686,20687,20688,20689,20690,20692,20696,20697,20700,20701,20704,20706,20707,20708,34747,20709,20800,20801,20802,20803,20851,20853,20854,20915,20918,20919,20920,20921,20922,20923,20925,20926,20927,20930,20952,21345,21346,21347,21348,21349,21350,21351,21352,21353,21354,21372,21374,21376,21377,21378,21379,21384,21385,21386,21388,21389,21392,21393,21396,21397,21717,21719,21725,21735,21790,21792,21795,21796,21798,21802,21803,21805,21806,21808,21810,21812,21814,21847,21848,21850,21856,21861,21862,21864,21865,21869,21871,21876,21878,21910,21911,21913,21914,21916,21917,21919,21920,21922,21923,22439,22446,22451,22459,22462,22470,22477,22480,22481,22580,22586,22589,22591,22592,22595,22598,22601,22603,22605,22610,22612,22613,22616,22618,22620,22663,22664,22666,22667,22668,22669,22670,22671,22673,22674,22676,22677,22678,22778,22780,22783,22785,23308,23310,23313,23315,23319,24127,24151,24152,24154,24155,24159,24160,24161,24163,24164,24165,24168,24170,24180,24181,24182,24183,24184,24185,24188,24189,24192,24194,24196,24197,24205,24206,24207,24225,24271,24272,24273,24274,24275,24276,24277,24278,24280,24291,24292,24293,24971,24972,24973,24991,24992,24993,24994,24995,24996,24997,24998,25001,25068,25067,25066,25071,25073,25074,25075,25076,25079,25080,25082,25081,25084,25087,25088,25089,25091,25090,25092,25093,25095,25094,25164,25173,25175,25176,25177,25178,25180,25182,25183,25211,25212,25214,25213,25215,25216,25218,25217,25219,25221,25220,25222,25224,25225,25226,25227,25228,25229,25230,25238,25239,25240,25241,25242,25243,25244,25245,25246,25247,25248,26319,26320,26322,26325,26326,26334,26337,26339,26340,26342,26348,26346,26347,26349,26351,26352,26353,26461,26473,26478,26480,26482,26481,26492,26491,26493,26494,26495,29096,29100,29231,29240,29327,29329,29330,29335,29337,38977,38976,31865,31866,31867,31868,31869,31870,31911,31910,31912,31913,31914,31915,31916,31917,31919,31920,31921,31922,32144,32145,32146,32147,33301,33477,33465,33466,33467,33468,33469,33470,33471,33472,33538,33539,33540,33541,33542,33543,33544,33866,33867,33868,33869,33972,33973,33974,33975,33976,33978,33979,33980,33999,34000,34006,34009,34105,34106,34107,34253,34258,34256,34260,34265,34267,34272,34275,34281,34284,34285,34286,34287,34291,34295,34297,34298,34307,34311,34313,34316,34744,34746,34749,34750,34841,34982,34984,34985,34986,35039,35152,35153,35154,35155,35156,35157,35540,35541,35543,35544,35545,35546,35547,35548,35549,35572,35573,35574,35575,35571,35570,35577,35576,35578,35579,35597,35598,35599,35600,35601,35602,35706,35705,35707,35708,35714,35713,35715,35717,35716,35718,35719,35720,35721,35722,35756,35757,35758,35762,35771,35772,35773,35774,35775,35801,35802,35803,35804,35805,35806,35940,35941,35942,35944,35943,35945,35946,35947,36545,36641,36642,36643,36644,36645,36646,36647,36648,36649,36650,36651,36652,36653,36654,36655,36656,36657,36658,36660,36659,36661,36662,36663,36664,36665,36666,36667,36668,36672,36674,36673,36675,36676,36677,36678,36681,36679,36680,36682,36683,36684,36685,36686,36687,36690,36693,36695,36696,36697,36699,36703,36762,36763,36764,36765,36766,36773,36803,36804,36805,36842,36843,36844,36845,36846,36847,36884,36885,36886,36998,37000,37001,37937,37942,37962,37963,37998,38125,38126,38127,38128,38129,38131,38132,38133,38134,38135,38136,38137,38138,38974,38979,38182,38184,38214,38195,38194,38199,38201,38203,38204,38208,38210,38212,38213,38215,38220,38228,38238,38246,38248,38251,38980,38324,38325,38326,38327,38328,38329,38330,38331,38332,38333,38334,38335,38336,38337,38338,38339,38340,38341,38342,38343,38344,38345,38346,38347,38348,38975,38349,38350,38351,38352,38353,38354,38355,38356,38357,38358,38359,38360,38362,38361,38363,38364,38365,38366,38367,39062,39068,39073,39071,39070,39131,38978,39009,39008,39010,39011,39012,39013,39014,39015,39016,39018,39019,39020,39021,39022,39126,39128,39132,39133,39134,39139,39140,39141,39143,39144,39145,39146,39147,29325,29324,29323,29242,29239,29237,37002,40802,40840,46127,41529,41530,41531,41532,41565,41569,41570,41573,41572,41575,35554,35553,35552,35551,35550,35974,35973,35972,35971,35970,42022,42025,42051,42066,42072,42755,42756,42758,42759,42761,42762,42776,42770,42771,42773,42774,42777,42778,42779,42780,42781,42782,42783,42792,42793,42794,42795,42799,42809,42810,42825,42818,42827,42831,42837,42840,42847,42852,42857,42863,42870,42882,42884,42885,42892,43534,43550,43576,43603,43611,43637,43646,43647,43648,43651,43652,43653,43655,43656,43667,43668,43680,43681,43683,43685,43686,43688,43689,43691,43710,43711,43712,43714,43733,43750,43739,43740,43742,43745,43748,43749,43960,43963,44268,42815,44592,44607,49620,44644,44773,44781,44776,44794,44797,44802,44803,44812,44817,44818,44829,45439,45379,45395,45415,45445,45456,45578,46087,46092,46093,46094,46118,46122,46125,46130,46307,49229,49232,49234,49236,49238,49277,49280,49283,49292,49286,49289,49291,49423,49428,49431,49436,49438,49442,49446,49448,49451,49456,49459,49465,49469,49471,49477,49482,49481,49483,49484,49551,49552,49553,49555,49554,49556,49557,49558,49561,49562,49565,49566,49567,49568,49569,49572,49570,49576,49574,49577,49578,49585,49579,49581,49583,49582,49584,49588,49587,49589,49591,49593,49594,49595,49596,49597,49598,49600,49599,49602,49604,49606,49607,49608,49609,49616,49618,49619,49621,49622,49623,49624,49625,49628,49627,49629,49630,49631,49633,49635,49636,49637,49638,49640,49639,49642,49641,49643,49644,49692,49684,49686,49687,49691,49693,49725,49727,49730,49732,49734,49736,49738,49741,49747,49748,49749,49751,49750,49753,49752,49754,49755,49756,49757,49763,49762,49764,49765,49773,49774,49777,49778,49780,49781,49782,49766,49759,49758,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,50006,50007,50011,50013,50014,50016,50018,50024,50022,50028,50029,50043,50045,50047,50048,50049,50050,50051,50052,50053,50054,50055,50057,50058,50061,50062,50063,50064,50065,50067,50069,50072,50073,50074,50075,50076,50077,50295,50296,50306,50305,50307,50309,50311,50313,50317,50323,50327,50328,50329,50330,51018,51007,51009,51011,51025,51033,51071,51073,51075,51077,51079,51081,51083,51085,51088,51089)) OR (categoryID IN (787)) ) AND ( enabled=1) AND status_off <> 1