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 (6078,6081,6090,6093,6098,6105,6110,6114,6145,6148,6151,6152,6156,6184,6188,6333,6335,6337,6340,6341,6342,6352,7924,7926,7927,7930,7932,7933,7982,7993,7997,7999,8617,8744,8746,8748,10287,10289,10291,10294,10295,10297,10299,10301,10303,10318,10679,11950,11955,11956,11957,11958,11959,11960,11961,11962,11963,11979,11980,11981,11982,11983,11984,11985,11986,11987,12078,12079,12081,12083,12086,12106,12110,12111,12150,12156,12159,14852,14858,15106,15297,15311,15312,15318,15321,15729,15730,15731,15732,15733,15734,15735,15736,15737,15738,15739,15748,15750,15755,15759,15760,15761,15765,15767,15768,15771,15773,15776,16170,16176,16177,16178,16179,16187,16189,16191,16193,16194,16196,16197,16333,16337,16340,16342,16344,16529,16749,16750,16751,16752,16753,16754,16755,16756,16840,16841,16855,16857,16926,16927,16928,16930,16934,16936,16938,16940,16941,16943,16944,16946,16947,16948,16950,16951,16953,16954,16956,16958,16960,16961,16963,16965,16967,16968,16971,16973,16974,16976,16978,16979,17736,17776,17791,17794,17796,17799,17800,17807,17810,17814,18124,18126,18129,18132,18143,18148,18151,18152,18154,18157,18159,18160,18193,18194,18196,18198,18220,18223,18228,18261,18263,18266,18269,18271,18273,18340,18341,18342,18343,18344,18345,18346,18351,18352,18353,18354,18355,18356,18359,18362,18363,18364,18365,18366,18367,18368,18369,18370,18371,18372,18456,18457,18464,18466,18542,18547,18551,39065,18555,19026,19028,19030,19057,19064,20286,20312,20322,20324,20334,20349,20411,20413,20415,20417,20419,20658,20659,20660,20664,20667,20670,20671,20672,20675,20677,20678,20679,20693,20697,20698,20699,20702,20703,20705,20852,20941,20943,20944,20946,20947,20951,20952,21345,21346,21347,21348,21349,21350,21351,21352,21353,21354,21374,21384,21385,21386,21389,21392,21393,21717,21719,21725,21729,21732,21734,21735,21764,21767,21771,21849,21857,21859,21863,21866,21871,21874,21876,21888,21899,21902,21904,21906,21908,21911,21912,21913,21915,21918,21919,21921,21923,21925,22612,22613,22616,22618,22620,22777,22781,22782,22784,22786,22788,22790,22808,22810,23283,23286,23287,23290,23293,23294,23295,23297,23299,23301,23303,24168,24170,24180,24181,24182,24183,24184,24185,24188,24189,24192,24194,24196,24979,24980,24981,24982,24983,24984,25004,25002,25003,25018,25105,25106,25108,25110,25111,25112,25115,25113,25114,25116,25117,25118,25130,25132,25131,25457,25460,25464,25468,25472,25474,26141,26144,26146,26155,26176,26157,26181,26160,26161,26164,26165,26210,26211,26213,26214,26529,26531,26532,26534,26535,26536,26540,26541,26542,26555,26556,26557,26558,26559,26560,26561,26562,26564,26565,26601,26604,26606,26609,26612,26614,26615,26617,26665,26666,26667,26668,26669,26670,26671,26672,26673,26674,26675,26676,26724,26735,26739,26742,26743,26744,26949,26950,26951,26953,26955,26952,26954,26959,26961,26965,26962,26963,26967,26969,26971,27016,27020,27025,27029,27032,27036,27039,27041,27043,27045,27049,27047,27052,27051,27054,27055,27056,27058,27057,27059,27060,27061,27062,27722,27741,27744,27750,27751,27760,27764,27768,27765,27769,27777,27782,27783,27787,27789,27790,27792,27794,27795,27797,27800,27801,27805,27814,27816,27820,27821,27823,27824,27825,27827,27831,27833,28994,28995,28996,28998,28997,28999,29000,29001,29004,29002,29003,29005,29006,29007,29008,29009,29010,29011,29012,29013,29014,29015,29016,29022,29017,29019,29018,29020,29021,29023,29024,29166,29169,29170,29173,29176,29178,29181,29186,29187,29188,29191,29194,29197,29199,29200,29201,29202,29203,29207,29243,29244,29245,29246,29248,29249,38977,30039,30058,30060,30062,30064,30164,30165,30167,30168,30166,30169,30170,30171,30172,30175,30177,30176,30178,30179,30180,30181,30173,30182,38976,30183,30185,30184,30186,30187,30188,30189,30190,30191,30193,30192,30194,31707,31708,31709,31710,31711,31712,31713,31714,31715,32586,32588,32036,32038,32039,32040,32041,32044,32093,32092,32094,32095,32096,32097,32098,32099,32100,32101,32102,32103,32104,32107,32105,32106,32110,32111,32112,32113,32115,32118,32119,32116,32117,32120,32121,32122,32123,32124,32125,32131,32132,32130,32139,32140,32141,32142,32288,32289,32291,32290,32292,32294,32295,32296,32297,32298,32305,32299,32307,32300,32306,32301,32302,32303,32314,32313,32315,32316,32317,32318,32319,32321,32320,32322,32323,32324,32325,32326,32327,32328,32329,32330,32331,32406,32407,32408,32409,32410,32411,32412,32413,32414,32491,32492,32493,32494,32536,32535,32533,32537,32539,32538,32540,32581,32584,32583,32585,32590,32594,32592,32596,32597,32599,32600,32696,32699,32697,32748,32698,32700,32701,32702,32703,32704,32763,32805,32807,32808,32809,32810,32811,32812,32762,33489,33492,33493,33494,33495,33509,33511,33512,33513,33538,33540,33545,33547,33738,33739,33795,33794,33796,33797,33798,33799,33800,33801,33802,33803,33804,33805,33806,33807,33808,33810,33809,33983,33981,33984,33986,33990,33989,33991,32765,32764,32761,33988,34042,34048,34057,34058,34059,34060,34061,34062,34063,34105,34064,34065,34106,34066,34107,34067,34068,34069,34070,34071,34072,34073,34096,34097,34098,34099,34100,34101,34503,34506,34505,34509,34507,34538,34539,34540,34541,34544,34545,34547,34548,34597,34600,34604,34605,34607,34615,34608,34611,34610,34614,34617,34621,34673,34674,34675,34677,34678,34676,34787,34791,34792,34793,34795,34796,34798,34826,34832,34834,34835,34836,36546,36548,36762,36763,36764,36765,36766,36773,36786,36787,36788,36789,36790,36791,36956,36957,36958,36959,36960,36961,36962,36964,36963,36965,36967,36966,36987,36988,36989,36990,36991,36992,36993,36994,36995,36996,36997,37017,37016,37015,37014,37018,37019,37020,37021,37022,37189,37190,37191,37192,37193,37194,37195,37196,37197,37199,37198,37200,37201,37202,37203,37204,37206,37205,37207,37208,37209,37210,37211,37212,37213,37214,37215,37216,37217,37218,37219,37220,37221,37222,37234,37235,37236,37237,37239,37238,37241,37240,37242,37243,37244,37245,37246,37247,37248,37432,37434,37435,37436,37437,37440,37438,37439,37442,37444,37445,37447,37449,37450,37452,37463,37464,37465,37763,37765,37766,37767,37764,37768,37812,37811,37813,37874,37876,37879,37882,38006,37968,37967,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,38000,38001,38002,38003,38004,38005,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38979,38980,38975,38497,38505,38507,38513,38512,38520,38524,38526,38527,38529,38528,38530,38531,38534,38533,38535,38536,38538,38540,38541,38545,38546,38559,38579,38690,38699,38702,38704,38705,38706,39062,39068,39071,39070,39131,38931,38934,38937,38940,38943,38947,38950,39008,39010,39011,39012,39013,39014,39015,39016,39018,39022,39019,39020,39021,39126,39128,39132,39133,39134,39139,39140,39144,39141,39143,39145,39146,39147,39234,39227,39228,39229,39230,39231,39232,39235,39236,39237,39265,39264,39266,39269,39267,39268,39270,39271,39299,39499,39500,39501,39502,39504,39505,39507,39508,39510,39513,39518,39521,39525,39523,39925,39927,39932,39957,39979,39984,36160,36165,36166,36167,36168,40850,40853,40854,40855,40856,40857,41211,41857,41799,41856,41858,41860,41864,41863,41865,41866,41868,41869,41871,41872,41875,41878,41880,41916,42134,42135,42137,42136,42139,42140,42142,42143,42144,42145,42146,42147,42161,42163,42166,42169,42171,42211,42212,42214,42213,42215,42216,42217,42218,42222,42219,42220,42221,42223,42224,42225,42226,42227,42228,42235,42238,42237,42236,42239,42240,42272,42274,42276,42278,42281,42307,42309,42311,42314,42316,42318,42431,42432,42433,42434,42643,42645,42650,42658,42681,42720,42723,42724,42727,42729,42917,42916,42930,42931,42933,42936,42949,42952,42954,42956,42962,42964,42966,43649,43654,43658,43682,43716,43715,43735,43743,43744,43746,43752,43756,43758,43759,43765,43737,43767,43768,43773,43888,43890,43894,43902,43904,43909,43913,43916,43966,43919,43920,43943,43948,43950,43951,43956,43959,43960,43963,43965,43970,43974,43973,43979,43978,43981,44004,44023,44006,44011,44009,44013,44012,44014,44016,44018,44017,44019,44020,44021,44026,44028,44029,44030,44031,44036,44037,44039,44044,44042,44050,44080,44051,44052,44055,44054,44056,44058,44061,44059,44062,44064,44065,44067,44068,44076,44077,44078,44079,44081,44082,44083,44085,44086,44088,44089,44090,44095,44093,44092,44094,44107,44109,44316,44317,44318,44319,44320,44322,44321,44323,44324,44325,44350,44352,44351,44353,44354,44356,44358,44359,44363,44364,44365,44366,44367,44368,44369,44370,44371,44444,44623,44622,44637,44669,44677,44683,44685,44689,44693,44695,44697,44698,44702,44725,44723,44724,44726,44899,44901,44903,44904,44909,44918,44929,44923,45361,45364,45375,45383,45399,45401,45405,45406,45426,45410,45418,45420,45429,45434,45444,45447,45523,45527,45528,45546,45548,45549,45551,45553,45555,45557,45543,45572,45574,45579,45580,45738,45739,45741,45746,45752,45787,45788,45789,45820,45794,45844,45846,45847,45853,45854,45855,45868,45871,45876,45877,45885,46133,46136,46194,46196,46303,46306,49230,49231,49235,49233,49237,49242,49239,49244,49248,49251,49267,49268,49269,49271,49270,49272,49273,49274,49275,49278,49281,49284,49287,49558,49561,49584,49604,49624,49641,49687,50110,50127,50141,50142,50206,50220,50231,50238,50240,50247,50260,50265,50310,50320,50324,50481,50482,50484,50483,50567,50568,50570,50571,50572,50573,50575,50576,50577,50578,50580,50582,50583,50584,50585,50601,50606,50609,50611,50632,50633,50635,50637,50638,50640,50642,50747,50752,50753,50756,50757,50760,50762,50767,51008,51010,51012,51024,51032,51034,51036,51038,51049,51052,51054,51056,51057,51058,51059,51060,51061,51062,51063,51064,51065,51066,51067,51068,51069,51070,51072,51074,51076,51078,51080,51082,51084,51086,51087,51090,51104,51107,51109,51110,51113,51186,51183,51190,51193)) OR (categoryID IN (747)) ) AND ( enabled=1) AND status_off <> 1