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 (7736,7771,7776,7782,7783,7787,12089,12093,12094,12096,12099,12100,12102,14824,14830,14911,14912,14914,14946,14956,14957,14958,14962,14964,14965,15112,15115,15299,15308,15317,15320,15325,16208,16216,16234,16239,16298,16303,16545,16553,16559,16565,16570,16664,16678,16949,16952,16958,16962,16966,16969,16991,16994,16997,17503,17734,18120,18127,18130,18135,18145,18146,18172,18175,18231,18236,18238,18241,18244,18280,18284,18287,18290,18293,18323,18357,18358,18467,18518,18521,18524,18527,18532,18534,18536,18538,18540,18596,18599,18603,18608,18611,18616,18618,19018,19020,19034,19040,19043,19045,19046,19048,19054,19069,19075,19083,19086,19088,19595,20436,20438,20440,20442,20444,20479,20480,20482,20483,20485,20486,20489,20491,22611,22614,22615,22617,22619,23307,23309,23311,23314,23316,23317,23320,23928,23958,23986,24023,24867,24889,24975,24976,24977,24978,25005,25006,25007,25008,25009,25129,25130,25131,25132,25412,25413,25416,25415,25417,25419,25457,25460,25464,25468,25472,25474,26651,26652,26656,26658,26662,26660,26664,31675,31676,31677,31678,31773,31776,31781,31790,31791,31792,31804,31910,31911,31912,31914,31913,31916,31915,31917,31923,31918,31925,31927,31926,31928,31929,31930,31931,32005,31999,32000,32006,32001,32002,32003,32004,32007,32149,32150,32152,32181,32182,32183,32184,32196,32197,32199,32198,32201,32202,32203,32379,32380,32378,32381,32382,32383,33416,33417,33418,33486,33487,33490,33491,33496,33498,33501,33992,33995,33998,33994,33996,33997,34229,34230,34231,34232,34233,34251,34338,34355,34357,34358,35521,35526,35541,35544,35549,35563,35562,35561,35564,36536,36539,36542,36544,36552,36554,36562,36566,36567,36568,36591,36855,37884,37888,37889,37894,37896,37898,37900,37902,37904,37935,37928,37932,38113,39098,39100,39101,39103,39104,18553,18549,18544,41839,41838,41842,41844,41848,41847,41851,41852,41886,41888,42908,42924,42932,42947,42955,42967,42968,42969,43684,43687,43690,43708,43709,43888,43894,43902,43909,43913,44518,44520,44522,44524,44523,44521,44519,44517,35452,44624,44635,44638,44672,44674,44754,44753,44756,44755,44757,44773,44802,44812,44817,44818,45709,45713,45714,45719,45718,46119,46120,46123,46128,46129,47286,49293,49295,49296,49297,49298,49299,49301,49302,49303,49304,49758,49759,49760,49766,49767,49768,49800,49803,49806,49804,49810,49807,49808,49811,49812,49813,49814,49815,49816,50012,50027,50044,50770,50773,50775,50780,50777,50781,51146,51155,51160,51165,51166,51172,51179)) OR (categoryID IN (743)) ) AND ( enabled=1) AND status_off <> 1