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,6357,6359,6364,6368,6370,6406,7924,7926,7927,7930,7932,7933,7982,7993,7997,7999,8004,8008,8009,8599,8602,8608,8622,8744,8746,8748,8752,8754,8755,8760,10290,10293,10300,10305,10309,10311,10313,10315,10317,10320,10325,10327,10665,10673,10676,10679,10700,10716,10720,11950,11955,11956,11957,11958,11959,11960,11961,11962,11963,12078,12079,12081,12083,12086,12106,12110,12111,12150,12156,12159,14852,14858,15106,15297,15301,15311,15318,15321,15729,15730,15731,15732,15733,15734,15735,15736,15737,15738,15739,16333,16337,16340,16342,16344,16529,16926,16930,16936,16950,16951,16954,16956,16960,16963,16968,18129,18132,18143,18148,18193,18194,18196,18198,18220,18223,18228,18366,18367,18368,18369,18370,18371,18372,18456,18457,18464,18466,19013,19015,19028,19030,20941,20943,20944,20946,20947,20951,23283,23286,23287,23290,23293,23294,23307,23309,23311,23314,23316,23317,23320,25153,25156,25154,25155,25157,25158,25159,25160,25161,26141,26144,26146,26155,26165,26157,26181,26160,26164,26161,26176,26210,26211,26213,26214,34250,34251,26651,26652,26655,26657,26656,26658,26659,26660,26662,26661,26663,26664,26724,26735,26744,26739,26742,26743,29102,29104,29105,29106,29107,29108,29126,29129,29134,29132,29136,29138,29130,30014,30017,30018,30020,30021,30026,34249,32144,32145,32146,32147,32150,32149,32151,32152,32168,32167,32169,32171,32170,32318,32319,32495,32496,32529,32530,32531,32532,32805,32807,32808,32812,32809,32810,32811,33489,33509,33511,33512,33513,33531,33533,33537,33538,33540,33545,33547,33834,33837,33835,33836,33839,33838,33840,33867,33992,33994,33995,33997,33998,33970,33866,33969,33869,33967,33868,33968,33996,34248,34252,34333,34334,34336,34337,34338,34341,34342,34343,34345,34347,34349,34350,34352,34353,34354,34355,34356,34357,34359,34358,34360,34361,34362,34363,34364,34365,34366,34367,34369,34370,34371,34372,34373,34374,34598,34599,34603,34601,34596,36549,36550,36570,36569,36571,36572,36573,36579,36580,36581,36582,37345,37346,37347,37348,37349,37350,37351,37352,37353,37354,37355,37356,38350,38351,38355,38352,38353,38354,38357,38356,38359,38358,38360,38373,38378,38412,38414,38413,38415,38416,38417,38418,38419,38420,38464,38468,38481,38485,38488,38720,38723,38722,38721,38725,38724,38726,38731,38732,38733,38735,38737,38788,38787,38776,38783,38791,38793,38796,38797,38795,38800,38801,38802,38803,38808,38809,38810,38811,38812,38813,38814,38815,38816,38817,38818,38819,38820,38821,38822,38823,38824,38825,38833,38828,38830,38829,38831,39173,39180,39181,39182,39184,39217,39218,39219,39220,39221,39222,39223,39224,39225,39527,39536,39538,39539,39541,39540,39543,39545,39544,39546,39548,39549,39550,39551,39552,41711,41710,41713,41715,41716,41717,41732,42175,42174,42180,42183,42185,42187,42692,42698,42695,42696,42702,43621,43622,43625,43627,44774,44775,44780,44784,44789,44788,44806,44809,44813,49195,49197,49199,49201,49203,49347,49350,49348,49349,49351,49352,49353,50310,50320,50324,50745,50768,50772,50789,50795,50797,50802,50803,50804,50808,50814,50943,50945,50947,50949,50951,50953,51082,51084,51087,51086,51090)) OR (categoryID IN (744)) ) AND ( enabled=1) AND status_off <> 1