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 (671,697,701,704,708,716,717,718,719,724,732,733,734,735,736,737,743,744,745,746,796,800,804,807,812,822,823,827,843,844,867,893,894,917,918,926,931,934,937,943,949,1089,1090,1115,1129,1130,1131,1136,1219,1332,1372,1373,1395,1396,1419,1788,1793,1794,1795,1800,1801,1822,1861,1862,1865,1866,1869,1873,1874,1877,1880,1882,1883,1894,1896,1911,1917,1948,1968,1972,2043,2074,2399,2414,2421,2422,2424,2429,2485,2490,2586,2603,2832,3006,3011,3018,3022,3027,3030,3039,3040,3042,3146,3179,3204,3439,3467,3594,3596,3607,3653,3753,3858,3881,3898,3899,3900,3912,3913,4110,4111,4114,4115,4132,4135,4138,4160,4163,4166,4548,4858,4925,4941,4966,4972,5005,37271,5039,5041,5112,5118,5119,5158,5159,5185,5186,5190,5191,5205,5206,5334,5354,5576,5578,5593,5614,5615,5616,5617,5618,5619,5620,5621,5734,5909,5910,5911,5912,5916,5917,5920,5921,5942,5987,6345,6346,6367,6433,6439,6441,6444,6949,7105,7175,7209,7210,7241,7725,7726,7727,7815,7913,7920,7937,7938,7948,7949,7954,7960,7970,7971,7974,7975,7976,7977,7984,7985,7986,7991,7992,8342,8344,9227,9233,9455,9456,10790,10791,10797,10798,11823,11824,11827,11833,11997,12000,12275,12310,12445,12452,12453,12461,12471,12520,12550,12769,12770,12787,12788,12880,12881,13354,13356,14315,14535,15468,15471,15506,15508,15509,15577,15594,15610,15800,15801,16224,17420,17455,17458,17539,17546,17547,17931,18004,18005,18007,18014,18015,18246,18587,18590,19606,19610,19660,19664,19761,20924,20967,21041,21062,21063,21064,21139,21233,21240,21293,21296,21789,21791,21793,21797,21799,21800,21816,21820,21827,22933,22961,22962,22968,22969,22990,23091,23095,23098,23101,23123,23142,23143,23147,23148,23166,23171,23174,23242,23449,23450,23453,23454,23457,23458,23463,23464,23469,23470,23488,23518,23519,23522,23523,23699,23731,23732,23883,24588,25143,25721,26266,26281,26291,26372,26611,26738,26804,26811,26813,26980,26988,27092,27334,27929,28165,28172,28273,28275,28288,28291,28559,28560,28561,28563,28564,28570,29157,29156,29162,29163,29193,29198,29214,29215,29216,29217,29218,29219,29220,29221,29222,29223,29224,29225,29227,29226,29328,29333,29356,29357,29358,29359,29426,29430,29443,29444,29452,29463,29464,29541,29542,29564,29612,29613,31358,31369,31373,31392,31400,31409,31424,31970,31971,31974,31975,32629,32756,32757,32750,32773,32829,32830,32962,32965,32969,32970,32973,33643,33644,33954,33958,34012,41662,34446,35179,35273,35446,35495,35499,35508,35641,47641,43000,37266,37274,37276,37280,37298,37631,37632,37636,37637,37638,37639,37640,37641,37655,37656,37659,37660,37661,37662,37674,37675,37676,37677,47647,47646,47652,47658,47661,47664,47655,47668,47622,47638,39060,38995,38999,39467,39611,39944,40985,40990,40994,41000,41001,41993,42085,42086,42090,42091,42826,42828,42909,43659,43660,43695,43697,43700,43707,43721,43777,43778,43885,43886,43897,43898,43907,43911,43915,44096,44097,44555,44717,44954,45457,45460,45490,45493,45500,45513,45512,46075,47226,47230,47236,47240,47247,47248,47263,47270,47271,47276,47288,47301,47295,47291,47314,47315,47320,47341,47352,47359,47390,47387,47393,47396,47401,47408,47411,47414,47417,47429,47433,47980,47984,48000,49125,49127,49142,49144,49161,49162,49167,49290,49294,49300,49316,49393,49406,49405,49413,49416,49417,49490,49491,49541,49668,49547,49542,49653,49656,49657,49667,49672,49673,49697,49698,49718,49719,49821,50033,50036,50518)) OR (categoryID IN (602)) ) AND ( enabled=1) AND status_off <> 1