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 (1585,1603,1632,1633,1710,1731,1735,3788,3789,3790,3791,3792,3793,3795,3796,3981,4002,4006,4007,4010,4011,4012,4013,4034,4035,4036,4037,4320,4321,4325,4343,4344,4442,4593,4658,4661,4662,4665,4666,4681,4723,4724,5222,5418,5421,5425,5426,5427,5831,6772,9900,9901,9902,9903,11889,11910,11914,11917,11920,12098,12120,12121,12540,12541,12542,12544,12545,12546,12555,12568,12594,13274,13282,14404,14434,14435,14436,14437,14479,14481,14485,14486,14493,14494,14498,14502,14505,14506,14509,14512,14566,14568,14606,14888,15025,15026,15030,15032,15033,15036,15038,15039,15176,15177,15178,15180,15182,15183,15329,15330,15331,15332,15380,16318,16324,16334,16353,16355,16357,16360,16368,16388,16457,16458,16460,16461,16502,16827,16828,16829,16830,16831,16832,16833,16895,16896,17071,17082,17107,17110,17266,17268,17270,20001,20002,20003,20389,20446,20447,20448,20449,20450,20464,24466,21281,21282,21283,21316,21317,21403,21405,21406,21410,21412,21413,21419,21426,21427,21430,21431,21475,21476,21478,21479,21590,22797,22798,22799,22907,22908,22923,23039,23040,23041,23042,23043,23044,23118,23119,23188,23189,23954,23956,23957,23960,24039,24040,24041,24043,24044,24047,24048,24049,24050,24962,48940,26548,26549,26603,26605,26607,26911,27188,27190,27192,27212,27213,27214,27215,27364,27367,27371,27943,27946,27947,27949,27961,27962,27963,27964,27965,28064,28135,28214,28573,29600,17072,48934,31154,31155,31156,31157,31164,31170,31171,31987,32245,32265,32266,32267,32293,33659,33660,33661,33663,33664,33665,33774,33781,40425,34290,34292,34293,34299,34303,34304,34741,34742,34743,34748,34752,34753,34755,48939,34900,34903,34905,34906,34907,35245,35247,35249,35252,35439,35438,35440,35500,35501,35504,35505,35789,35813,37557,37556,37558,37559,37560,37561,39584,39583,39097,39099,39107,39108,39138,39137,39148,39149,39152,39153,39161,39165,39185,39186,44239,44240,39317,39416,39434,39435,39440,39443,39444,39449,39450,39456,39457,39531,39532,39533,39572,39598,39599,39622,39621,39627,39628,39638,39669,39722,39720,39762,39763,39764,39766,39792,39793,39796,39797,40245,40268,40269,40282,40281,40283,40284,40285,40286,40329,40330,40338,40339,40341,40344,40343,40357,40356,40358,40359,40365,40366,40367,40368,40369,40426,40453,40454,40482,40481,40483,48651,48650,48635,48626,48627,42095,42294,43484,43486,43514,43515,43516,43522,43523,44185,44186,44187,44195,44194,44196,44241,44242,44243,44244,44246,44251,44253,44307,44308,44309,44310,44311,44312,44423,44490,44491,44492,44495,44494,44496,44497,44498,44499,44500,44544,44912,44978,44979,44980,45000,45003,45004,45008,45010,45014,45015,45016,45017,45129,45145,45153,45155,45258,45259,45260,45261,45262,45263,45264,45265,45266,45267,45285,45366,45368,45371,45374,45376,45378,45382,46410,46411,46427,46466,46765,46766,46767,46768,46769,46770,46771,46772,47223,47225,48226,48228,48240,48241,48242,48243,48244,48245,48248,48249,48280,48281,48282,48283,48284,48286,48287,48341,48342,48343,48344,48932,49111,49112,49113,50707,50810,50864)) OR (categoryID IN (699)) ) AND ( enabled=1) AND status_off <> 1