144 Table './occupy7_superchargers/zen_products_description' is marked as crashed and last (automatic?) repair failed
in:
[select count(distinct p.products_id) as total FROM (zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c ) LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p2c.products_id = p.products_id AND p2c.products_id = pd.products_id AND (p2c.categories_id = 506 OR p2c.categories_id in ( 1077, 1078, 1079, 1080, 1113, 1395, 1494, 2115, 1081, 1082, 1490, 1083, 1084, 1491, 1123, 1124, 1396, 1493, 2114, 1125, 1126, 1393, 1492, 1911, 2046, 2110, 2111, 2112, 2113, 1127, 1128, 1237, 1303, 1383, 1384, 1385, 1455, 1487, 1488, 1489, 1771, 2217, 1618, 1657, 1693, 1888, 1916, 2209, 1299, 1300, 1386, 1451, 1515, 1519, 1520, 1668, 2011, 2212, 1301, 1302, 1387, 1452, 1516, 1521, 1522, 1919, 2013, 1381, 1382, 1548, 2038, 1390, 1549, 1550, 1551, 1895, 2037, 1909, 1449, 1450, 1514, 1517, 1518, 1542, 1749, 2012, 1453, 1454, 1523, 1629, 1910, 2014, 1495, 1511, 1512, 1524, 1525, 1602, 1619, 1620, 1684, 1690, 1704, 1905, 1772, 1773, 1894, 2004, 2005, 2210, 2211, 1105, 1106, 1107, 1108, 1209, 1210, 1211, 1368, 1369, 1370, 1371, 1372, 1465, 1513, 1616, 1890, 1180, 1349, 1350, 1351, 1352, 2108, 1196, 1197, 1198, 1199, 1357, 1363, 1365, 1553, 1748, 1117, 1536, 1118, 1462, 1531, 1746, 1621, 1120, 1121, 1122, 1212, 1213, 1214, 1552, 1599, 1615, 1889, 2006, 1174, 1175, 1176, 1177, 1342, 1343, 1344, 1345, 2035, 2109, 1184, 1346, 1347, 1348, 2107, 2101, 2102, 2103, 2104, 1188, 1189, 1353, 1354, 1355, 1356, 2106, 1328, 1329, 1530, 2105, 1204, 1205, 1206, 1207, 1208, 1326, 1327, 1706, 1992, 1359, 1360, 1373, 1374, 1375, 1376, 1378, 1456, 1532, 1460, 1461, 1538, 1539, 1622, 1623, 1624, 1625, 1703, 1989, 1640, 2197, 2198, 2199, 2200, 2201, 1705, 2040, 2041, 1109, 1110, 1111, 1336, 1628, 1752, 2059, 1497, 1498, 1547, 1753, 1908, 1238, 1540, 1613, 1239, 1541, 1240, 1241, 1242, 1333, 1334, 1335, 1783, 2060, 1337, 1338, 1496, 1751, 2047, 1597, 1702, 1906, 1701, 1907, 1136, 1137, 1295, 1296, 1397, 1398, 1399, 1138, 1139, 1140, 1533, 1141, 1142, 1143, 1162, 1167, 1168, 1259, 1260, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1534, 1425, 1426, 1230, 1231, 1388, 1526, 1486, 1234, 1235, 1236, 1389, 1500, 1499, 1501, 1257, 1258, 1261, 1262, 1263, 1264, 1265, 1527, 1528, 1266, 1267, 1268, 1435, 2216, 1270, 1283, 1284, 1285, 1401, 1402, 1403, 1409, 1407, 1408, 1410, 1293, 1294, 1286, 1287, 1288, 1404, 1405, 1406, 1546, 1543, 1544, 1545, 1289, 1290, 1291, 1292, 1330, 1331, 1332, 1577, 1639, 1685, 1416, 1417, 1427, 1428, 1429, 1446, 1447, 1430, 1431, 1432, 1433, 1434, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1445, 1695, 1696, 1697, 1698, 1699, 1700, 1502, 1503, 1506, 1504, 1507, 1505, 1508, 1509, 1510, 1603, 1604, 1605, 1653, 1655, 1654, 1656, 1691, 2049, 2050, 2052, 2053, 2051, 2054, 2055, 2042, 2043, 2213, 2214, 2215)) AND m.manufacturers_id = 20 AND ((pd.products_name LIKE '%e-force%' OR p.products_model LIKE '%e-force%' OR m.manufacturers_name LIKE '%e-force%' OR (mtpd.metatags_keywords LIKE '%e-force%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%e-force%' AND mtpd.metatags_description !='')) ))]