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 (672,683,749,855,856,860,863,864,905,906,956,957,1182,1183,1219,1328,1329,1442,1557,1562,1572,1575,1577,1578,1579,1580,1596,1605,1606,1607,1611,1617,1618,1619,1620,1622,1626,1636,1637,1640,1641,1642,1660,1664,1665,1668,1671,1672,1673,1674,1689,1692,1699,1703,1712,1713,1718,1719,1721,1722,1732,1782,1788,1822,1880,1889,1894,1896,1907,1911,1913,1921,1931,1932,1940,1944,1955,1964,1965,1968,1975,1977,1982,1983,1987,1988,1993,2000,2006,2009,2014,2018,2022,2026,2027,2037,2050,2051,2056,2057,2249,2276,2287,2403,2415,2429,2458,2460,2471,2473,2482,2483,2487,2489,2492,2497,2503,2505,2507,2554,2557,2558,2896,2923,3111,3132,3415,3417,3481,3491,3502,3513,3520,3539,3544,3571,3575,3596,3780,3781,3784,3785,3786,3787,3817,3821,3879,3884,3885,3886,3887,3905,3948,3951,3962,3963,3969,3973,3978,3994,3997,4003,4008,4049,4052,4053,4065,4070,4071,4076,4083,4087,4098,4169,4276,4279,4322,4367,4371,4532,4541,4545,4582,4585,4594,4597,4621,4634,4651,4682,4683,4694,4766,4769,4772,4773,4777,4781,5016,5021,5031,5047,5054,5057,5060,5077,5079,5083,5084,5089,5133,5158,5159,5171,5172,5173,5180,5181,5185,5186,5194,5200,5201,5205,5206,5213,5214,5219,5220,5223,5226,5228,5231,5243,5244,5334,5429,5648,5649,5663,5664,5667,5668,5672,5673,5678,5679,5683,5684,5687,5688,5692,5693,5710,5711,5716,5717,5783,5784,5786,5788,5955,5956,5957,5974,6470,6816,6817,6818,6825,6826,6827,6834,6835,6836,6859,6860,6861,6866,6867,6873,6874,6878,6879,6884,6887,6916,6919,6936,6937,6970,6971,6977,6978,6989,6994,6995,7107,7108,7201,7209,7241,7396,7510,7815,7913,7920,7937,7938,7942,7943,8311,8312,8313,8328,8329,8333,8334,8337,8338,8339,8356,8357,8358,8363,8376,8399,8400,8447,9430,9431,9438,9440,9502,9507,9634,9893,9897,9915,10790,10797,10798,10833,10836,10901,10902,11258,11261,11356,11358,11416,11457,11459,11461,11493,11495,11520,11522,11559,11561,11770,11773,11792,11795,11797,11798,11810,11827,11828,11836,11837,11840,11849,11870,11871,11872,11873,11874,11875,11876,11877,11883,11884,11893,11894,11911,11931,11948,11988,11993,11994,12003,12006,12011,12033,12037,12045,12052,12058,12065,12074,12075,12264,12268,12272,12287,12315,12318,12321,12324,12486,12512,12532,12562,12569,12575,12580,12584,12674,12679,12862,12917,13161,13163,13164,13168,13169,13170,13171,13258,13259,13267,13279,13295,13300,13319,13328,13376,13391,13392,13394,13397,13399,13407,13408,13413,13415,13423,13426,13443,13458,13466,13467,13471,13472,13488,13489,13507,27861,13515,27860,13517,27854,27853,13525,13537,13557,13570,13571,13575,13579,14154,14187,14204,14206,14209,14217,14218,14219,14220,14223,14263,14266,14274,14277,14281,14294,14386,14459,14465,14482,14483,14492,14497,14578,14579,14602,14603,14708,14757,14789,14792,14800,14805,31340,14984,15009,15050,15078,15094,15117,15123,15191,15192,15241,15246,15357,15374,15375,15433,15603,16183,16186,16199,16206,16288,16291,16297,16809,16810,16812,16813,16852,16894,17025,17032,17033,17036,17038,17042,17092,17099,17100,17521,17524,17533,17575,17578,17581,17613,17620,17622,17730,17733,17748,17751,17753,17830,17831,17832,17833,17839,17840,18030,18121,18125,18133,18305,18309,18322,18376,18377,18379,18383,18391,18402,18969,18986,18989,18992,18999,19002,19004,19035,19077,19090,19274,19281,19282,19283,19284,19285,19712,19714,19717,19720,19916,19938,19940,20497,20498,20499,20500,20655,20776,20777,20778,20779,20785,20786,20787,20788,21258,21266,21394,21495,21571,21572,21573,21574,21621,21622,21658,21668,21669,21670,21671,21673,21674,21754,21755,21756,21757,21759,21760,21761,22127,22731,22735,22736,23000,23001,23032,23073,23706,23724,23735,23759,23769,23770,23778,23795,23839,23840,23854,23855,23879,23963,24054,24055,24062,24065,24070,24089,24121,24399,24402,24526,24633,24665,24681,24690,24704,24705,24720,24740,24741,24797,24798,24799,24800,14919,24808,24809,25163,25165,26304,26327,26376,26406,26425,26433,26530,26528,26588,26755,26761,26839,26847,26869,26873,26898,26948,27063,27068,27073,27083,27086,27089,27113,27116,27119,27284,27296,27305,1568,27762,27761,27778,27780,27839,27845,27846,27872,27873,27930,27969,27971,27983,27993,28002,28043,28045,28066,28073,28084,28114,28136,28179,28231,28266,28283,28288,28301,28486,28500,28501,28502,28503,28950,28953,28958,28968,28971,28977,28983,28986,29035,29160,29198,29236,29238,29258,29295,29296,29344,29429,29565,29567,29568,29571,29573,29577,29580,29581,29582,29583,29604,29612,29613,29621,29622,30131,30132,30139,30152,30153,30154,30155,30195,30198,30274,30281,30335,30372,30376,30380,30384,30405,30419,30420,30451,30452,30462,30469,30470,30488,30489,30512,30584,30586,30592,30593,30609,30610,30631,30632,30637,30670,30673,30698,30713,30720,30721,30736,30738,30760,30761,30773,30775,30782,30783,30796,30797,30801,30802,30821,30820,30898,30899,30908,30911,30914,30917,30920,30951,30958,30962,31015,31018,31030,31033,31045,31046,31236,31250,31256,31257,31284,31285,31293,31297,31298,31301,31302,31306,31307,31308,31309,31310,31314,31315,31324,26913,31341,31344,31373,31385,31400,31403,31418,31421,31424,31547,31875,31874,31885,31986,32129,32240,32244,32595,32606,32620,32623,32642,32643,32648,32691,32694,32742,32749,32840,32853,32855,32896,32897,32938,32948,32950,33024,33143,33145,33149,33150,33158,33160,33161,33173,33175,33208,33243,33367,33554,33557,33566,33565,33592,33591,33600,33599,33603,33616,33625,33626,33630,33641,33756,33851,33910,33914,33926,33940,33965,34023,34022,34024,34546,34552,35177,35213,35215,35218,35228,35234,35248,35254,35269,35594,35641,35767,35770,35816,35830,35848,35854,35873,35885,35903,35905,35907,35995,35998,36001,36004,36042,36045,36047,36050,36069,36074,36313,36347,36350,36353,36456,36457,36460,36503,36506,36508,36510,36512,36514,37284,37361,37367,47341,47719,39111,38853,39004,39488,39517,39840,40252,40725,40726,42106,42107,43077,43332,43356,43366,43417,43432,43492,43495,43499,43500,43507,43559,43583,43618,43630,43633,43636,43659,43660,43664,43665,43732,43734,43736,43830,43833,45021,45050,45065,45069,45121,45125,45240,45412,45468,45478,45493,45664,45682,46038,46067,46400,46492,46495,46496,46504,46663,47291,47295,47301,47303,47314,47315,47320,47352,47359,47369,47372,47375,47378,47385,47384,47386,47387,47390,47393,47405,47417,47426,47437,48143,48272,48294,48425,48508,48514,49325,49324,49366,49367,49405,49406,49419,49421,49495,49525,49656,49770,49783,50514,50892)) OR (categoryID IN (609)) ) AND ( enabled=1) AND status_off <> 1