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 (1327,1693,1698,1704,1735,1954,1969,1973,2080,2502,2506,2545,3766,3891,3892,3893,3894,3895,3914,3915,3916,3917,3990,3991,3992,3993,3995,3996,4010,4011,4012,4013,4028,4045,4046,4105,4106,4116,4117,4118,4119,4227,4249,4250,4556,5134,5136,5418,5421,5425,5426,5427,5492,5493,5494,5495,5496,5497,5498,5499,5500,5831,5832,5833,5835,5836,5994,5998,5999,6000,6252,6253,6258,6931,6932,6933,6934,8346,8347,8384,8386,8391,8442,9424,9623,9630,9631,9633,9648,9663,9767,9768,9855,9864,9883,9884,9886,9889,9901,9903,10782,10783,10785,10802,10804,10898,10899,11348,12004,12005,12454,12456,12574,12893,12921,12922,12923,12924,12928,12930,13282,14424,14425,14566,14568,14626,14866,14906,14908,14909,14910,14977,14978,14979,14980,15018,16850,16851,16861,16895,16896,17121,17122,17272,18094,18414,18415,18515,18516,18575,19678,26619,26620,26644,26749,26750,26751,26752,26753,26754,27918,27921,27920,29421,29424,29423,29448,29450,29458,29608,31528,32650,32651,33648,33946,34466,34706,34707,34709,34708,34710,34711,35274,35245,35247,35496,35497,35503,35502,47629,39023,39416,39434,39435,43089,43090,43412,43508,43509,47698,43727,43731,48342,48341,48343,48344,48897,49189,50488,50920,50921)) OR (categoryID IN (591)) ) AND ( enabled=1) AND status_off <> 1