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 (6034,6071,6076,7245,7248,7252,7254,7256,10690,10701,10717,10721,10724,10727,10732,10735,11772,11776,11782,11786,15298,15302,15307,15313,15319,15775,16193,16323,16326,16328,16330,16336,16338,16341,16343,16345,16530,16665,16667,16668,16669,16672,16681,16686,16687,16689,16690,16691,16692,16694,16695,16697,16699,16720,16722,16729,16731,16733,16734,16983,16984,16985,16987,16989,16992,16995,16998,17504,17735,18177,18179,18184,18231,18234,18236,18237,18238,18240,18241,18242,18244,18245,18276,18280,18281,18283,18284,18285,18286,18287,18288,18289,18290,18291,18292,18293,18294,18451,18454,18461,18462,18465,18467,18537,18538,18557,18562,18563,18565,18566,18568,18569,18571,18572,18574,18596,18597,18598,18599,18600,18603,18604,18608,18610,18611,18613,18614,18615,18618,18938,18939,18941,18943,18948,18950,18953,20397,20412,20414,20416,20418,20420,20437,20439,20441,20443,20445,21850,21856,21864,21865,21869,21871,21878,21897,21901,21903,21905,21907,21910,21914,21920,21922,22663,22664,22666,22667,22668,22672,22677,22678,24294,24295,24296,24297,24298,24299,24301,24304,24307,24312,24313,24314,24315,24320,24864,24888,24967,24968,24969,24970,24985,24986,24987,24988,24989,24990,25011,25012,25014,25015,25016,25105,25107,25106,25108,25109,25111,25110,25112,25113,25114,25393,25396,25397,25398,25401,25402,25421,25422,25429,25432,25434,25435,25481,25478,25476,25482,25486,25487,26655,26657,26663,26659,26661,32173,32172,32174,32176,32175,32191,32190,32193,32192,32195,32194,32218,32220,32221,32222,32223,32217,32225,32226,32228,32229,32230,32224,32305,32533,32535,32536,32537,32805,32807,32808,32809,32810,32811,32812,33301,33303,33460,33465,33466,33467,33468,33469,33470,33471,33472,33497,33499,33502,33505,33507,33800,33798,33799,33801,33802,33803,33805,33804,33806,33807,33808,33809,33810,34042,34048,34057,34058,34059,34060,34061,34062,34063,34064,34065,34106,34107,34105,34098,34099,34100,34101,41663,41667,41671,34256,34258,34265,34272,34275,34281,34284,34285,34286,34287,34291,34295,34297,34298,34307,34311,34313,34316,41672,34423,34424,34425,34426,34427,34428,34429,34569,34568,34570,34571,34572,34584,34585,34586,34590,34592,34632,34633,34634,34635,34636,34637,34660,34659,34657,34661,35597,35598,35599,35600,35601,35602,35670,35671,35672,35673,35674,35675,35676,35684,35685,35686,35687,35688,35689,35690,35691,35692,35693,35694,35695,35696,35697,35724,35725,35726,35727,35728,35730,35732,35783,35786,35787,35788,35790,35791,35792,35794,35793,35796,35798,35797,35800,35925,35926,35927,35928,35929,35959,35960,35961,35962,35964,36165,36122,36120,36119,36121,36123,36131,36132,36616,36618,36617,36619,36620,36621,36622,36623,36898,36899,36900,36901,36902,36903,36934,36935,36936,36937,36938,36939,36994,36995,36997,36996,38055,37093,37086,37087,37095,37094,37096,37097,37167,37168,37171,37169,37170,37883,39684,37924,37926,37929,37930,37934,38060,38063,38066,41675,38069,38077,38076,38078,38079,38080,38081,38101,38099,38325,38328,38329,38332,38333,38334,38337,38373,38378,38412,38413,38414,38415,38418,38416,38417,38419,38420,38426,38422,38424,38428,38430,38468,41677,41691,39180,39184,39218,39221,39224,34253,34267,41470,41468,41467,39477,39479,39511,39514,39519,39522,39526,39652,39657,39664,39665,39667,39670,39673,39676,39682,39686,39695,39697,39704,39708,39706,39917,39913,39916,39920,39919,39921,39910,39986,39991,39993,39995,39998,39999,41680,41681,36167,36168,41684,41685,40894,40896,41027,41029,41031,41034,41035,41357,41037,41038,41039,41053,41055,41119,41123,41688,41255,41257,41256,41258,41259,41260,41269,41270,41472,41474,41486,41492,41495,41497,41496,41498,41499,41606,41608,41613,41614,41643,41644,41647,41648,41655,41656,41659,41692,41695,41698,41776,41779,41782,42150,42148,42152,42155,42157,42159,42173,42177,42179,42181,42184,42718,42721,42722,42726,42725,42728,42802,42834,42844,43967,43991,43995,44001,44002,44155,44159,44163,44166,44168,44175,44176,44177,44178,44179,44231,44233,44236,44237,44621,44634,44667,44671,44675,44680,46202,46228,46236,46243,46263,46334,46335,46336,46337,46395,46406,46449,46456,46515,46530,46531,46533,46535,46542,49196,49198,49200,49202,49204,49725,49734,49738,49854,49856,49859,49875,49880,49963,49972,49983,49977,49992,49995,50003,50217,50221,50223,50222,50234,50233,50235,50236,50241,50243,50249,50250,50251,50339,50345,50391,50393,50398,50401,50406,50409,50436,50439,50444,50448,50451,50456,50460,50644,50646,50650,50653,50655,50658)) OR (categoryID IN (749)) ) AND ( enabled=1) AND status_off <> 1