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 (6375,6379,6382,6385,6388,6414,6416,6419,6421,6423,9913,10286,10307,12091,12095,12097,12101,12103,12162,12166,12169,12172,12175,13829,13831,13832,13833,13834,14969,14970,14971,16204,16215,16225,16231,16233,16237,16296,16301,16302,16306,16307,16312,16314,16321,16532,16534,16537,16540,18151,18154,18157,18159,18160,18451,18454,18467,18468,18518,18519,18521,18522,18524,18525,18527,18529,18541,18546,18550,18557,18565,18568,18571,18608,18610,18611,18613,18614,18615,18616,18617,19008,19012,19014,19016,19017,19018,19019,19020,19022,19024,19025,19059,19067,20271,20274,20276,20395,20399,20404,20406,20408,20422,20427,20429,20431,20434,20680,20683,20684,20689,20704,20706,20853,22669,22807,23296,23298,23300,23302,23304,23955,23959,24020,24025,24184,24188,24189,24192,24194,24196,24299,24307,24312,24313,24314,24315,24320,24864,24888,24967,24968,24969,24970,25067,25073,25075,25088,25092,25119,25121,25123,25124,25126,25125,25127,25128,25164,25173,25176,25175,25177,25393,25396,25397,25398,25401,25402,25437,25448,25453,25445,25449,25450,25456,26673,26674,27746,27758,27764,27772,27776,27789,27798,27806,27810,27814,27828,27833,29170,29176,29187,29188,29199,29202,29362,29364,29366,30027,30035,30037,31055,31058,31059,31063,31069,31071,31076,31078,31087,31091,31094,31097,31098,31100,31103,31108,31114,31123,31127,31137,31994,31995,31996,31997,31998,32046,32050,32049,32052,32053,32054,32143,32399,32396,32398,32400,33301,33303,33424,33425,33426,33460,33470,33471,33472,33519,33522,33524,34454,34442,34462,34467,34481,34483,34518,34519,34520,34521,34522,34524,34526,34528,34529,34530,34575,34574,34576,34577,34582,34580,34579,34581,34583,34646,34647,34648,34649,34650,34651,34652,34654,34826,34832,34834,34835,34836,36545,36547,36557,36558,36559,36561,36563,36564,36565,36587,36751,36752,36753,36754,36755,36756,36757,36759,36758,36760,36801,36802,36803,36804,36805,36827,36828,36829,36830,36831,36893,36894,36895,36896,36897,37789,37788,37791,37790,37792,37793,37794,37872,39684,38373,38378,38412,38414,38413,38418,38415,38416,38417,38419,38426,38420,38422,38424,38428,38430,38432,38434,38442,38444,38445,38446,38447,38448,38450,38449,38452,38454,38456,38459,38466,39091,39090,39095,39094,39096,39238,39242,39245,39248,39251,39255,39257,39259,39261,39263,18554,39652,39657,39664,39665,39670,39673,39682,39695,39704,40908,40910,41635,41638,41639,41642,41709,41712,41714,41731,41733,41735,41736,22809,42161,42163,42166,42169,42171,42544,42557,42563,42565,42597,42562,42556,42543,42538,42547,42559,42611,42613,42620,42621,42918,42919,42921,42924,42908,42926,42928,42929,42932,42934,42935,42937,43147,43156,43157,43161,43164,43171,43177,43178,43179,44518,44520,44522,44524,44765,44764,44766,45545,45542,45544,45547,49206,49208,49210,49212,49222,49224,49226,49228,49255,49258,49261,49264,49266,49268,49269,49272,49273,49275,49423,49431,49436,49442,49456,49459,49469,49819,49817,49820,49822,50022,50050,50062,51115,51118,51124,51127,51128,51132)) OR (categoryID IN (746)) ) AND ( enabled=1) AND status_off <> 1