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 (5934,5936,5939,6325,6329,6330,7906,7908,7915,7918,11950,11955,11956,11957,11958,12160,12163,12164,12167,12170,12173,12174,13721,13723,13790,13791,13794,15311,15312,15318,15748,15750,15755,15759,15765,15767,15768,16176,16178,16179,16189,16194,16196,16197,16750,16751,16928,16936,16943,16947,16971,18335,18336,18340,18341,18342,18343,18344,18345,18346,18351,18352,18353,18354,18355,18356,20411,20413,20415,20417,20419,21912,21915,21921,21925,22777,22781,22782,22784,23295,23297,23299,23301,23303,24168,24170,24180,24181,24182,24183,24185,24294,24295,24296,24297,24298,24301,24304,24323,24326,24327,24329,24330,24333,27016,27745,27800,27813,29231,43014,32036,32038,32039,32040,32041,32044,33516,33517,33518,34042,34048,34057,34058,34059,34060,34061,34062,34063,34064,34065,34066,34067,34068,34069,34070,34071,34072,34073,34095,34096,34097,34098,34099,34100,34101,34105,34106,34107,34253,34254,34256,34258,34259,34262,34266,34267,34268,34272,34274,34281,34284,34285,34286,34287,34291,34295,34297,34298,34307,34308,34310,34311,34312,34313,34315,34316,34317,37941,38200,38222,38235,38243,38708,38710,38748,38754,38789,38790,38794,38792,39234,39227,39228,39229,39230,39231,39232,39235,39236,39237,48038,48043,42006,39304,39335,39402,42978,40850,40853,40854,40855,40856,40857,41211,41492,41495,41497,41496,41498,41499,41799,18334,42011,42023,42024,42053,42067,42071,42162,42164,42165,42167,42168,42170,42217,42218,42219,42220,42221,42222,42223,42224,42225,42226,42227,42228,42272,42274,42276,42278,42281,42387,42975,42388,42389,42390,42394,42391,42393,42395,42396,42416,42424,42426,42427,42425,42422,42420,42414,42431,42432,42433,42434,42598,42602,42603,42604,42606,42607,42623,42626,42641,42649,42654,42659,42663,42664,42670,42674,43005,43006,42983,42979,42853,42855,42859,42862,42867,42872,42879,42898,42901,42903,43013,43019,43021,43191,43194,44316,44317,44318,44319,44320,44321,44322,44323,44324,44325,44350,44358,44359,44368,44369,44370,44371,44446,44448,44452,44457,44773,44802,44812,44817,44818,44899,44901,44903,44904,44909,44918,44923,44929,45442,45168,45170,45370,45397,45398,45404,45409,45416,45431,45452,45455,45533,45534,45536,45535,45539,45538,45540,45541,45543,45549,45553,45551,45555,45574,45537,45738,45739,45741,45746,45752,45787,45788,45795,45789,45796,45794,45814,45820,45844,45846,45847,45853,45854,45855,45862,45868,45871,45876,45877,46598,46600,46603,46606,46607,46609,47239,47264,47268,47302,47448,47470,47476,47485,47486,47528,48044,48051,48052,50295,50306,50323,50840)) OR (categoryID IN (755)) ) AND ( enabled=1) AND status_off <> 1