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 (768,1307,1311,1315,1355,1356,1911,1913,3125,3126,5150,5434,5435,5446,5524,5525,5529,5544,5552,5567,5568,41376,41375,6199,6220,6255,6257,11256,11257,11259,11260,11292,11293,11295,11296,11313,11314,11316,11317,11355,11357,11384,11385,11387,11388,11399,11400,11436,11437,11456,11458,11460,11468,11492,11505,11506,11519,11520,11521,11522,11536,11558,11559,11560,11561,11585,11586,11593,11594,11890,11908,11911,11921,12226,12235,12256,12258,12259,12445,12461,12512,12525,12527,12543,12547,12557,12584,12589,12592,12895,13010,13011,13012,13013,13027,13028,13029,13076,13077,13476,14283,14287,14293,14295,14305,14308,14311,14338,14339,14354,14367,14368,14369,14469,14523,15136,15139,15205,15377,15548,15873,16146,16369,16373,17894,17895,18693,18754,20224,20227,20250,20258,20260,20380,20387,20392,20465,20509,20521,20523,20719,20720,20721,20798,20799,20808,20809,20901,20958,20959,20967,21034,21096,21097,21223,21224,21225,21291,21293,21296,21320,21404,21409,21411,21415,21416,21429,21433,21480,21486,21488,21545,21550,21554,21555,21556,21588,21589,21593,21594,21607,21620,21621,21622,21623,21625,21626,21627,21628,21629,21634,21635,21828,21830,22141,22142,22143,22144,22145,22146,22554,22922,22927,22928,23109,23110,23449,23450,23453,23454,23457,23458,23499,24088,24467,24532,24796,24804,24805,24965,25150,25151,25469,26263,26304,26399,26563,26571,26596,26822,26826,27216,27219,27220,27221,27898,28007,28018,28039,28046,28063,28066,28165,28172,28298,28301,28455,28456,29162,29163,29193,29198,29214,29215,29216,29217,29218,29219,29220,29221,29222,29223,29224,29225,29226,29227,29328,29333,29544,29621,29622,29643,29662,29676,29677,29678,29679,29680,29681,29682,29683,29684,29762,29763,29764,29795,30670,30673,31051,31166,31362,31369,31373,31451,31457,31458,31459,31460,31502,31980,31989,32069,39557,39560,32460,32461,32462,32463,32464,32517,32516,33121,33149,33150,33860,33871,33887,33892,33896,33905,33917,33921,33962,34039,34047,34084,34085,34086,34115,34119,34123,34211,34300,34301,34302,34314,34318,34320,34686,34739,35353,35356,35446,35495,35618,36528,36529,36530,37298,37300,37369,37370,37371,37399,37400,37424,37431,37488,37514,37516,37520,47672,47706,38961,38964,39585,39121,39120,38835,38839,38857,38860,39060,38967,38993,38994,38995,38999,39309,39323,39328,41971,39353,39467,39534,39553,39569,39574,39573,39575,39623,39625,39626,39634,39645,39723,39724,39735,39748,40238,40363,48653,48652,48594,48625,48624,48612,40635,40637,40652,40653,40676,40677,40985,40994,41050,41051,41052,41426,41427,41456,41457,41455,41581,41965,42090,42091,42465,42466,44615,43318,43320,43322,43325,43329,43330,43335,43399,43441,43454,43507,43513,43543,43545,43546,43618,43633,43811,43812,44096,44097,44292,44588,44665,44740,44991,44990,44993,44994,44996,45223,45246,45421,45424,45427,45664,46098,46099,46106,46107,46161,46527,46549,46550,46642,46643,46675,46676,46687,46698,46707,46708,46720,46722,46723,46713,46856,46853,46854,46857,46855,46863,46864,46865,46866,46867,46868,46869,46954,46955,46956,46962,46970,47018,47019,47020,47021,47022,47024,47055,47056,47084,47088,47089,47105,47110,47118,47204,47205,47207,47227,47289,47292,47742,47785,47794,47795,48166,48225,48227,48247,48259,48334,48488,48563,48564,48593,48654,48655,48834,48835,48836,48837,48909,48913,48914,49087,49136,49137,49140,50364,50369,50370,50413,50414,50415,50476,50479,50509,50533,50540,50557,50529,50715,50703,50704,50708,50711,50729,50730,50735,50736,50869,50870,50876,50893,50894,50998,50999,51000,51001,51002,51003,51004,51005,51013,51014,51016,51019,51020,51021,51197,51198,51204,51244,51245,51251,51252,51253,51254,51255,51256,51257,51258)) OR (categoryID IN (760)) ) AND ( enabled=1) AND status_off <> 1