Table './f42102_db/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 (673,676,706,707,708,709,710,711,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,735,736,738,739,740,741,742,744,746,747,748,749,753,754,755,757,758,759,760,761,762,763,764,765,766,767,768,770,771,783,791,792,793,794,795,797,798,800,801,802,803,804,805,806,807,808,809,811,812,813,814,815,816,817,820,821,822,823,824,825,826,827,828,829,830,831,832,833,835,836,837,838,840,845,846,849,851,852,853,860,861,862,863,864,865,866,867,868,871,872,873,874,875,885,886,891,892,896,900,905,926,928,929,930,931,932,933,934,935,936,937,938,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,958,959,960,961,962,963,964,966,967,968,969,970,971,972,973,974,975,976,977,980,1009,1010,1014,1017,1018,1019,1020,1021,1034,1037,1038,1073,1074,1075,1076,1077,1078,1084,1085,1086,1087,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1101,1183,1184,1185,1186,1187,1212,1213,1214,1216,1217,1218,1219,1220,1221,1222,1223,1224,1226,1227,1231,1232,1233,1234,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1248,1249,1250,1251,1259,1261,1262,1263,1264,1265,1266,1267,1268,1269,1275,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1325,1326,1327,1328,1330,1331,1332,1333,1335,1337,1338,1339,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1354,1355,1356,1359,1360,1361,1362,1363,1364,1365,1368,1369,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1409,1410,1411,1413,1416,1417,1418,1419,1420,1421,1423,1424,1436,1439,1441,1442,1443,1444,1446,1447,1448,1449,1454,1455,1456,1457,1458,1461,1465,1470,1474,1475,1476,1477,1478,1479,1480,1481,1490,1491,1492,1493,1494,1495,1496,1497,1498,1500,1501,1502,1503,1506,1507,1508,1509,1510,1511,1512,1513,1517,1518,1519,1521,1522,1525,1526,1535,1571,1572,1573,1574,1576,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1700,1701,1702,1705,1706,1763,1764,1765,1766,1767,1768,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1805,1806,1807,1808,1809,1810,1811,1812,1813,1818,1819,1820,1821,1822,1823,1824,1825,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1844,1845,1846,1847,1848,1849,1850,1893,1894,1895,1896,1897,1898,1907,1910,1911)) OR (categoryID IN (629,632,633,634,644,628)) ) AND ( enabled=1)