Table './toyzezr_wa/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 (26204,26213,26217,26221,26225,26232,26233,26236,26237,26238,26239,26241,26245,26246,26247,26252,26253,26256,26268,26292,26293,26294,26295,26296,26301,26321,26351,26353,26354,26355,26356,26358,26360,26364,26365,26366,26367,26369,26371,26405,26406,26407,26408,26409,26410,26411,26566,26567,26634,26671,26696,26700,26755,26904,26906,26910,26978,26993,26995,27064,27076,27077,27078,27079,27080,27082,27332,27360,27362,27363,27365,27366,27367,27368,27393,27398,27495,27523,27524,27547,27561,27564,27565,27649,27650,27651,27748,27750,27757,27815,27816,27817,27818,27820,27821,27822,27823,27824,27825,27826,27827,27833,27843,27844,27845,27846,27847,27848,27849,27850,27851,27852,28030,28031,28032,28033,28109,28110,28126,28167,28176,28177,28178,28195,28210,28211,28212,28213,28328,28364,28367,28368,28369,28370,28372,28373,28374,28375,28378,28379,28380,28381,28382,28383,28384,28385,28386,28387,28388,28410,28411,28412,28413,28414,28415,28416,28417,28418,28419,28420,28421,28422,28423,28424,28425,28427,28428,28429,28430,28431,28432,28433,28434,28435,28436,28437,28438,28439,28440,28441,28442,28443,28444,28445,28446,28447,28448,28449,28450,28451,28452,28453,28454,28455,28456,28457,28463,28500,28505,28522,28523,28524,28525,28526,28527,28528,28529,28530,28531,28535,28536,28573,28575,28617,28618,28619,28620,28621,28622,28623,28636,28637,28638,28639,28641,28642,28643,28644,28645,28646,28653,28654,28655,28656,28657,28658,28662,28663,28664,28665,28666,28667,28668,28669,28670,28685,28686,28687,28688,28707,28726,28749,28764,28766,28842,28849,28850,28851,28852,28876,28900,28901,28904,28905,28911,28912,28913,28914,28915,28916,28965,28966,28967,28968,28969,28970,28971,28972,28973,28974,28975,28976,28977,28978,28979,28983,28984,28995,28996,28997,28998,28999,29000,29001,29002,29003,29004,29005,29006,29007,29041,29044,29045,29052,29053,29054,29055,29056,29057,29058,29059,29060,29061,29062,29063,29064,29065,29066,29067,29068,29069,29070,29071,29072,29073,29074,29075,29076,29077,29078,29079,29080,29081,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29093,29094,29095,29096,29097,29098,29099,29100,29101,29102,29103,29105,29106,29107,29108,29109,29110,29111,29112,29113,29114,29115,29116,29117,29118,29119,29120,29121,29122,29128,29129,29130,29131,29132,29133,29134,29135,29139,29143,29144,29150,29151,29152,29172,29180,29181,29182,29183,29194,29195,29196,29197,29198,29199,29200,29201,29202,29203,29204,29205,29206,29207,29208,29209,29210,29211,29212,29213,29214,29215,29216,29217,29218,29219,29220,29221,29236,29250,29251,29252,29260,29261,29262,29267,29268,29269,29270,29271,29272,29273,29274,29275,29276,29277,29278,29279,29280,29281,29282,29283,29284,29308,29309,29323,29336,29346,29347,29348,29349,29403,29404,29405,29410,29421,29423,29431,29432,29448,29449,29450,29451,29455,29511,29512,29533,29542,29560,29561,29562,29563,29565,29566,29567,29580,29594,29595,29596,29597,29598,29599,29600,29601,29602,29603,29604,29618,26265,26292,26293,26294,26347,26359,26360,26404,27365,27649,27650,27651,28505,29041,26366,26540,26700,27360,27361,28573,28849,28876,29250,29431,29432,36973,26246,26263,26264,26354,26355,26356,26368,26994,26996,28167,29326,26237,26239,26247,26252,26253,26256,26270,26295,26296,26301,26350,26351,26353,26368,26369,26371,26634,26696,26755,26906,26907,26909,26978,26993,26995,26996,27062,27064,27363,27364,27365,27366,27367,27495,27521,27522,27523,27524,27547,27561,27649,27650,27651,27833,28030,28031,28032,28033,28448,28500,28535,28536,28575,28619,28620,28641,28642,28653,28654,28657,28658,28707,28726,28764,28766,28913,29041,29052,29053,29055,29056,29057,29070,29071,29072,29084,29085,29092,29093,29098,29099,29100,29109,29110,29128,29129,29130,29131,29132,29133,29134,29135,29150,29151,29152,29180,29199,29203,29204,29205,29209,29211,29212,29213,29214,29215,29216,29217,29218,29219,29220,29221,29270,29271,29274,29275,29276,29281,29284,29599,30630,31941,33040,33048,33049,33067,37226,37199,37171,37175,37174,37227,37228,26394,36930,27065,27066,28378,28379,28448,28913,29424,29445,29446,29447,27378,29143,29144,29323,30595,30624,30625,27398,27742,27748,27750,27757,27760,27762,28055,28328,29146,29510,30381,32661,32662,32663,32664,32665,32666,32667,32668,32675,32676,32677,34520,34543,31993,28458,28460,28461,28462,31995,28623,31994,29139,29140,29143,29144,29403,29404,29405,29410,29413,29423,29448,29449,29450,29451,29616,29617,31927,31928,31929,31996,31997,31998,31999,32000,32001,32002,32003,32049,32061,32062,32063,32064,36963,36966,36967,36968,26203,26259,26266,26298,26299,26300,26306,26307,26370,26532,26541,26596,27366,27367,27566,27834,27835,27874,28404,28405,28474,28475,28486,28487,28488,28489,28513,28569,28609,28610,28853,28975,28976,28977,28978,28979,29050,29051,29146,29158,29159,29160,29237,36751,29542,30373,30374,30379,30380,30381,30831,30832,30833,30834,30835,30836,30837,30838,30839,30840,30841,30842,30843,30844,30845,30846,30847,30848,30849,30850,30851,30852,30853,30858,30859,30860,30861,30862,30863,30864,30865,30866,30867,30868,30869,30870,30871,30872,30873,30874,31967,31982,31983,32010,35686,37199,37198,37243,26252,26293,26294,26295,26296,26369,26371,26904,26993,27365,27524,27547,27649,27650,27651,29209,29211,37226,37227,37228,36646,28410,28411,28412,28413,28414,28415,28416,28417,28418,28419,28420,28421,28422,28423,28424,28425,28426,28427,28965,28966,28967,28968,28969,28970,28971,28972,28973,28974,28983,28984,28995,28996,28997,28998,28999,29000,29001,29002,29003,29004,29005,29006,29007,29267,29268,29269,30496,30497,30498,30499,30500,30501,30502,30503,30504,30505,30506,30507,30508,30518,30521,30522,30524,36624,37042,37043,37044,37045,28522,28523,28524,28525,28526,28527,28528,28529,28530,28531,29336,29346,29347,29348,29349,28378,28379,29100,29181,29183,37176,26368,29205,29221,29236,29580,29599,29602,30377,33041,36932,36933,36934,37197,33041,33891,33892,26303,26304,26305,26308,26309,26535,26536,26537,26539,26542,26607,26608,26609,26701,26702,26703,26704,26705,26985,27060,27061,27063,27562,27563,27692,28147,28209,28329,28640,29039,29040,29225,29226,29227,29228,29233,29234,29235,29238,29239,29240,29241,29242,29247,29248,29253,29255,29258,29511,29512,29533,29534,29545,29546,29549,29560,29561,29562,29563,29565,29566,29567,31964,31966,37235,37239,37240,37244,36744,36750,36749,36747,36746,36745,30731,30732,30733,30734,30735,30736,30737,30738,30739,30740,30741,30742,30743,30744,30745,30746,30747,30748,30749,30750,30751,30752,30753,30754,30755,30756,30757,30758,30759,30760,30761,30762,30763,30764,30765,30766,30767,30768,30769,30770,30771,30772,30773,30774,30775,30776,30777,30778,30779,30780,30781,30782,30783,30784,30785,30786,30787,30788,30789,30790,30791,30792,30793,30794,30795,30796,30797,30798,30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823,30824,30825,30826,30827,30828,30829,30830,36717,36716,36748,36718,36714,36713,36720,36729,36741,36731,36735,36736,36742,36734,36738,36739,36740,36737,36727,36719,36712,36715,36722,36726,36732,36743,36730,36711,36724,36723,36725,36710,36721,36733,36728,35711,35712,35713,35714,35715,35716,35717,35718,35719,35720,35721,35722,35723,35724,35725,35726,35727,35728,35729,35730,35731,35732,35733,35734,35735,35736,35737,35738,35739,35740,35741,35742,35743,35744,35745,35746,35747,35748,35749,35750,35751,35752,35753,35754,35755,35756,35757,35758,35759,35760,35761,35762,35763,35764,35765,35766,35767,35768,35769,35770,35771,35772,35773,35774,35775,35776,35777,35778,35779,35780,35781,35782,35783,35784,35785,35786,35787,35788,35789,35790,35791,35792,35793,35794,35795,35796,35797,35798,35799,35800,35801,35802,35803,35804,35805,35806,35807,35808,35809,35810,35811,35812,35813,35814,35815,35816,35817,35818,35819,35820,35821,35822,35823,35824,35825,35826,35827,35828,35829,35830,35831,35832,35833,35834,35835,35836,35837,35838,35839,35840,35841,35842,35843,35844,35845,35846,35847,35848,35849,35850,35851,35852,35853,35854,35855,35856,35857,35858,35859,35860,35861,35862,35863,35864,35865,35866,35867,35868,35869,35870,35871,35872,35873,35874,35875,35876,35877,35878,35879,35880,35881,35882,35883,35884,35885,35886,35887,35888,35889,35890,35891,35892,35893,35894,35895,35896,35897,35898,35899,35900,35901,35902,35903,35904,35905,35906,35907,35908,35909,35910,35911,35912,35913,35914,35915,35916,35917,35918,35919,35920,35921,35922,35923,35924,35925,35926,35927,35928,35929,35930,35931,35932,35933,35934,35935,35936,35937,35938,35939,35940,35941,35942,35943,35944,35945,35946,35947,35948,35949,35950,35951,35952,35953,35954,35955,35956,35957,35958,35959,35960,35961,35962,35963,35964,35965,35966,35967,35968,35969,35970,35971,35972,35973,35974,35975,35976,35977,35978,35979,35980,35981,35982,35983,35984,35985,35986,35987,35988,35989,35990,35991,35992,35993,35994,35995,35996,35997,35998,35999,36000,36001,36002,36003,36004,36005,36006,36007,36008,36009,36010,36011,36012,36013,36014,36015,36016,36017,36018,36019,36020,36021,36022,36023,36024,36025,36026,36027,36028,36029,36030,36031,36032,36033,36034,36035,36036,36037,36038,36039,36040,36041,36042,36043,36044,36045,36046,36047,36048,36049,36050,36051,36052,36053,36054,36055,36056,36057,36058,36059,36060,36061,36062,36063,36064,36065,36066,36067,36068,36069,36070,36071,36072,36073,36074,36075,36076,36077,36078,36079,36080,36081,36082,36083,36084,36085,36086,36087,36088,36089,36090,36091,36092,36093,36094,36095,36096,36097,36098,36099,36100,36101,36102,36103,29147,27844,29148,32004,28463,29149,29308,27845,27843,32005,27847,27846,27848,29150,29151,29152)) OR (categoryID IN (1906,1676,1681,2080,1759,2071,1982,2086,2107,1983,1735,1826,1827,1848,1849,1910,2016,2048,2049,2050,2052,2109,2111,2116,2139,2191,2294,2289,1662)) ) AND ( enabled=1) AND ((`p`.`in_stock` + `p`.`warehouse` + `p`.`warehouse2`) > 0 )