Britain's Living Seas: Our Coastal Wildlife and How We Can Save it

£16.99

Discover the incredible diversity of life within our seas and learn how we can all play a role in protecting and conserving it.

Our seas are home to an abundance of fascinating creatures and stunning habitats. From spectacular kelp forests to intricate rocky reefs and from mud plains to open ocean, the British Isles have a diversity of marine ecosystems that rival those seen on any nature documentary. Yet, for generations, we have been slowly suffocating life beneath the waves. Decades of unsustainable exploitation, endless pollution and a warming climate have had a devastating effect on our marine habitats.

However, it's not too late to make a difference and change course. Written in collaboration with the Wildlife Trusts, Britain's Living Seas provides a user-friendly and richly illustrated guide to coasts around the British Isles, uncovering the diversity of life within a range of marine habitats and the life-giving services that they provide us. Outlining how their very existence is under threat, marine biologist Hannah Rudd presents an alternative and sustainable future for the management of our seas.

We can all do our bit as individuals too. Through practical steps such as re-thinking what we eat, our relationship with plastic and how we spend our money, we can become marine conservationists in our everyday lives and help to create a healthier future for our oceans. Everyone can discover more about the wonders within the waters that surround us and play a part in rebuilding our connection with the natural world.

Available in Paperback.

Time Δ Debug Message - Perch Runway 3.2
1783472620.18720 [906] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM swt_pages_staging p LEFT JOIN swt_page_routes pr ON p.pageID=pr.pageID LEFT JOIN swt_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM swt_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
1783472620.21190.0247Matched route: shop/products/[slug:s]
1783472620.2120.0001Server address: 216.73.217.142
1783472620.2120Using master page: /templates/pages/shop/product.php
1783472620.2120Page arguments: 
Array
(
    [0] => /shop/products/britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it
    [s] => britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it
    [1] => britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it
)
1783472620.21220.0002 [1] SELECT * FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.21310.0008 [86] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
1783472620.21460.0016 [1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
1783472620.21510.0005INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
1783472620.21660.0015 [1] SELECT * FROM swt_shop_cart WHERE cartID=22759321
1783472620.2170.0004 [1] SELECT * FROM swt_shop_cart WHERE cartID=22759321
1783472620.21740.0004 [nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2026-07-08 01:03:00' AND saleTo>'2026-07-08 01:03:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
1783472620.21840.001 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
1783472620.36370.1453Using template: /templates/shop/products/product.html
1783472620.36390.0002 [162] SELECT catID, catPath FROM swt_categories
1783472620.36510.0011 [250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
1783472620.36640.0014Using template: /templates/pages/attributes/seo.html
1783472620.36680.0003 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/shop/products' OR regionPage='*')
1783472620.36750.0007 [nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM swt_content_index idx JOIN swt_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN swt_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=655 AND idx.itemRev=0)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
1783472620.36880.0013 [82] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783472620.37170.003 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.37240.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472620.37440.0021Using template: /templates/navigation/ps_nav_template.html
1783472620.37450 [6] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.37520.0008 [4] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.37570.0005 [29] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.37840.0026 [10] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.37940.001 [7] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.38010.0007 [9] Using template: /templates/navigation/ps_nav_template_children.html
1783472620.38290.0029 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' OR pageSortPath='/shop/products' LIMIT 1
1783472620.38390.0009 [1] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition
1783472620.38620.0024 [1] Using template: /templates/navigation/breadcrumbs.html
1783472620.38660.0004 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
1783472620.4360.0493 [1] Using template: /templates/shop/products/product.html
1783472620.43650.0005 [1] SELECT * FROM swt_categories ORDER BY catTreePosition ASC
1783472620.44180.0053 [1] SELECT * FROM swt_shop_currencies WHERE currencyID=47 LIMIT 1
1783472620.44320.0013 [1] SELECT * FROM swt_shop_products WHERE productSlug='britains-living-seas-our-coastal-wildlife-and-how-we-can-save-it' AND productDeleted IS NULL LIMIT 1
1783472620.45630.0131 [4322] SELECT DISTINCT idx.itemID FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
1783472620.52750.0712 [1875] SELECT DISTINCT idx.itemID FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
1783472620.58410.0566 [nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('10', '100', '1000', '1001', '1002', '1003', '1004', '1005', '1006', '1007', '1008', '1009', '101', '1010', '1011', '1012', '1013', '1014', '1015', '1016', '1017', '1018', '1019', '102', '1020', '1021', '1022', '1023', '1024', '1025', '1026', '1027', '1028', '1029', '103', '1030', '1031', '1032', '1033', '1034', '1035', '1036', '1037', '1038', '1039', '1040', '1041', '1042', '1043', '1044', '1045', '1046', '1047', '1048', '1049', '105', '1050', '1051', '1052', '1053', '1054', '1055', '1056', '1057', '1058', '1059', '106', '1060', '1061', '1062', '1063', '1064', '1065', '1066', '1067', '1068', '1069', '107', '1070', '1071', '1072', '1073', '1074', '1075', '1076', '1077', '1078', '1079', '108', '1080', '1081', '1082', '1083', '1084', '1085', '1086', '1087', '1088', '1089', '109', '1090', '1091', '1092', '1093', '1094', '1095', '1096', '1097', '1098', '1099', '11', '110', '1100', '1101', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109', '111', '1110', '1111', '1112', '1113', '1114', '1115', '1116', '1117', '1118', '1119', '112', '1120', '1121', '1122', '1123', '1124', '1125', '1126', '1127', '1128', '1129', '113', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '114', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '115', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '116', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '1168', '1169', '117', '1170', '1171', '1172', '1173', '1174', '1175', '1176', '1177', '1178', '1179', '118', '1180', '1181', '1182', '1183', '1184', '1185', '1186', '1187', '1188', '1189', '119', '1190', '1191', '1192', '1193', '1194', '1195', '1196', '1197', '1198', '1199', '12', '120', '1200', '1201', '1202', '1203', '1204', '1205', '1206', '1207', '1208', '121', '1211', '1213', '1214', '1215', '1216', '1217', '1218', '1219', '122', '1220', '1221', '1222', '1223', '1224', '1225', '1226', '1227', '1228', '1229', '123', '1230', '1231', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '124', '1240', '1241', '1242', '1243', '1244', '1245', '1246', '1247', '1248', '1249', '125', '1250', '1251', '1252', '1253', '1254', '1255', '1256', '1257', '1258', '1259', '126', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1268', '1269', '127', '1270', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1278', '1279', '128', '1280', '1281', '1282', '1283', '1284', '1285', '1286', '1287', '1288', '1289', '129', '1290', '1291', '1292', '1293', '1294', '1295', '1296', '1297', '1298', '1299', '13', '130', '1300', '1301', '1302', '1303', '1304', '1305', '1306', '1307', '1308', '1309', '131', '1310', '1311', '1312', '1313', '1314', '1315', '1316', '1317', '1318', '1319', '132', '1320', '1321', '1322', '1323', '1324', '1325', '1326', '1327', '1328', '1329', '133', '1330', '1331', '1332', '1333', '1334', '1335', '1336', '1337', '1338', '1339', '134', '1340', '1344', '1345', '1347', '1348', '1349', '135', '1350', '1351', '1352', '1353', '1354', '1355', '1356', '1357', '1358', '1359', '136', '1360', '1361', '1362', '1363', '1364', '1365', '1366', '1367', '1368', '1369', '137', '1370', '1371', '1372', '1373', '1375', '1378', '1379', '138', '1380', '1381', '1382', '1383', '1384', '1385', '1386', '1387', '1388', '1389', '139', '1390', '1391', '1392', '1393', '1394', '1395', '1396', '1397', '1398', '1399', '14', '140', '1400', '1401', '1402', '1403', '1404', '1405', '1406', '1407', '1408', '1409', '141', '1410', '1411', '1412', '1413', '1414', '1415', '1416', '1418', '1419', '142', '1420', '1421', '1422', '1423', '1424', '1425', '1426', '1427', '1428', '1429', '143', '1430', '1431', '1432', '1433', '1434', '1435', '1436', '1437', '1438', '1439', '144', '1440', '1441', '1442', '1443', '1444', '1445', '1447', '1448', '1449', '145', '1454', '1455', '1456', '1457', '1458', '1459', '146', '1460', '1461', '1462', '1463', '1464', '1465', '1466', '1467', '1468', '1469', '147', '1470', '1471', '1472', '1473', '1474', '1475', '1476', '1477', '1478', '1479', '148', '1480', '1481', '1482', '1483', '1484', '1485', '1486', '1487', '1488', '1489', '149', '1490', '1491', '1492', '1493', '1494', '1495', '1498', '1499', '15', '150', '1500', '1501', '1502', '1503', '151', '1511', '1512', '1513', '1514', '1515', '1516', '1517', '1518', '1519', '152', '1520', '1521', '1522', '1523', '1524', '1525', '1526', '1527', '1528', '1529', '153', '1530', '1531', '1532', '1533', '1534', '1535', '1536', '1537', '1538', '1539', '154', '1540', '1541', '1542', '1543', '1544', '1545', '1546', '1547', '1548', '1549', '155', '1550', '1551', '1552', '1553', '1554', '1555', '1556', '1557', '1558', '1559', '156', '1560', '1561', '1562', '1563', '1564', '1565', '1567', '1568', '1569', '157', '1570', '1571', '1572', '1573', '1574', '1576', '1577', '1578', '1579', '158', '1580', '1581', '1582', '1583', '1584', '1585', '1586', '1587', '1588', '1589', '159', '1590', '1591', '1592', '1593', '1594', '1595', '1597', '1598', '1599', '16', '160', '1600', '1601', '1602', '1603', '1604', '1605', '1606', '1607', '1608', '1609', '161', '1610', '1611', '1612', '1613', '1614', '1615', '1617', '1618', '1619', '162', '1620', '1621', '1622', '1623', '1624', '1625', '1626', '1628', '1629', '163', '1630', '1631', '1632', '1633', '1634', '1635', '1638', '1639', '164', '1640', '1641', '1642', '1643', '1644', '1645', '1646', '1647', '1648', '1649', '165', '1650', '1651', '1652', '1653', '1654', '1655', '1657', '1658', '1659', '166', '1660', '1661', '1662', '1663', '1664', '1665', '1666', '1667', '1668', '1669', '167', '1670', '1671', '1672', '1673', '1674', '1675', '1676', '1677', '1678', '1679', '168', '1680', '1681', '1682', '1684', '1685', '1686', '1687', '1688', '169', '1690', '1691', '1692', '1693', '1694', '1695', '1696', '1697', '1698', '1699', '17', '170', '1700', '1701', '1702', '1703', '1704', '1705', '1706', '1707', '1708', '1709', '171', '1710', '1711', '1712', '1713', '1714', '1715', '1717', '1718', '1719', '172', '1720', '1721', '1722', '1723', '1724', '1725', '1726', '1727', '1728', '1729', '173', '1730', '1731', '1732', '1733', '1734', '1735', '1739', '174', '1740', '1741', '1744', '1745', '1746', '1747', '1748', '1749', '175', '1750', '1751', '1753', '1754', '1755', '1756', '1757', '1758', '1759', '176', '1760', '1761', '1762', '1763', '1764', '1765', '1767', '1768', '1769', '177', '1770', '1772', '1773', '1774', '1775', '1776', '1777', '1778', '1779', '178', '1780', '1781', '1782', '1783', '1784', '1785', '1787', '1788', '1789', '179', '1790', '1791', '1792', '1793', '1794', '1795', '1796', '1797', '1798', '1799', '18', '180', '1800', '1801', '1802', '1803', '1804', '1806', '1807', '1808', '1809', '181', '1810', '1811', '1812', '1814', '1815', '1816', '1817', '1818', '1819', '182', '1820', '1821', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '183', '1830', '1831', '1832', '1833', '1834', '1835', '1836', '1837', '1838', '1839', '184', '1840', '1841', '1843', '1844', '1845', '1846', '1847', '1848', '1849', '185', '1850', '1851', '1852', '1853', '1854', '1856', '1857', '1859', '186', '1860', '1861', '1862', '1863', '1865', '1866', '1867', '1868', '1869', '187', '1871', '1872', '1873', '1874', '1875', '1876', '1877', '1878', '1879', '188', '1880', '1881', '1882', '1883', '1884', '1885', '1887', '1888', '1889', '189', '1890', '1891', '1892', '1893', '1894', '1895', '1896', '1897', '1898', '1899', '19', '190', '1900', '1901', '1902', '1903', '1904', '1905', '1906', '1907', '1908', '1909', '191', '1910', '1911', '1912', '1913', '1914', '1915', '1916', '1917', '1918', '1919', '192', '1920', '1921', '1922', '1923', '1924', '1925', '1926', '1927', '1928', '1929', '193', '1930', '1931', '1932', '1933', '1934', '1935', '1936', '1937', '1938', '1939', '194', '1940', '1941', '1942', '1943', '1944', '1945', '1946', '1947', '1948', '1949', '195', '1950', '1951', '1952', '1953', '1954', '1955', '1956', '1957', '1958', '1959', '196', '1960', '1961', '1962', '1963', '1964', '1965', '1966', '1967', '1968', '1969', '197', '1970', '1971', '1972', '1973', '1975', '1976', '1977', '1978', '1979', '198', '1980', '1981', '1982', '1983', '1984', '1985', '1986', '1987', '1988', '1989', '1990', '1991', '1992', '1993', '1994', '1995', '1996', '1997', '20', '2000', '2001', '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009', '201', '2010', '2011', '2012', '2013', '2014', '2015', '2016', '2017', '2018', '2019', '202', '2020', '2021', '2022', '2023', '2024', '2025', '2026', '2027', '2028', '2029', '203', '2030', '2031', '2032', '2033', '2034', '2035', '2036', '2037', '2038', '2039', '204', '2040', '2041', '2042', '2043', '2044', '2046', '2047', '2048', '2049', '205', '2050', '2051', '2052', '2053', '2054', '2055', '2056', '2057', '2058', '2059', '206', '2060', '2061', '2062', '2063', '2064', '2065', '2066', '2067', '2068', '2069', '207', '2070', '2071', '2072', '2073', '2074', '2075', '2076', '2077', '2078', '2079', '208', '2080', '2081', '2082', '2083', '2084', '2085', '2086', '2087', '2088', '2089', '209', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2099', '21', '210', '2100', '2101', '2102', '2103', '2104', '2105', '2106', '2108', '2109', '211', '2110', '2111', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '212', '2120', '2121', '2122', '2123', '2124', '2125', '2126', '2127', '2128', '2129', '213', '2130', '2131', '2132', '2133', '2134', '2135', '2137', '2138', '2139', '214', '2140', '2141', '2142', '2143', '2144', '2145', '2146', '2147', '2148', '2149', '215', '2150', '2151', '2152', '2153', '2154', '2155', '2156', '2157', '2158', '2159', '216', '2160', '2161', '2162', '2163', '2164', '2165', '2166', '2167', '2168', '2169', '217', '2170', '2171', '2172', '2173', '2174', '2175', '2176', '2177', '2178', '2179', '218', '2180', '2181', '2182', '2183', '2184', '2185', '2187', '2188', '2189', '219', '2190', '2191', '2192', '2193', '2194', '2195', '2196', '2197', '2198', '2199', '22', '220', '2200', '2201', '2202', '2203', '2204', '2205', '2206', '2207', '2208', '2209', '221', '2210', '2213', '2214', '2215', '2216', '2217', '2218', '2219', '222', '2220', '2221', '2222', '2223', '2224', '2225', '2226', '2227', '2228', '2229', '223', '2230', '2231', '2232', '2233', '2234', '2235', '2236', '2237', '2238', '2239', '224', '2240', '2241', '2242', '2243', '2244', '2245', '2246', '2247', '2248', '2249', '225', '2250', '2251', '2252', '2253', '2254', '2255', '2256', '2257', '2258', '2259', '226', '2260', '2261', '2262', '2263', '2264', '2265', '2266', '2267', '2268', '2269', '227', '2270', '2271', '2272', '2273', '2274', '2275', '2276', '2277', '2278', '2279', '228', '2280', '2281', '2282', '2283', '2284', '2285', '2286', '2287', '2288', '2289', '229', '2290', '2291', '2298', '2299', '23', '230', '2300', '2302', '2303', '2304', '2305', '2307', '2308', '2309', '231', '2310', '2311', '2312', '2314', '2315', '2316', '2317', '2318', '2319', '232', '2320', '2321', '2322', '2323', '2324', '2325', '2326', '2327', '2328', '2329', '233', '2330', '2331', '2333', '2337', '2338', '2339', '234', '2340', '2341', '2342', '2348', '2349', '235', '2350', '2351', '2352', '2353', '2354', '2355', '2356', '2357', '2358', '2359', '236', '2360', '2361', '2362', '2363', '2364', '2365', '2366', '2367', '2368', '2369', '237', '2370', '2371', '2372', '2373', '2374', '2375', '2376', '2377', '2378', '2379', '238', '2380', '2382', '2383', '2384', '2385', '2386', '2387', '2388', '2389', '239', '2390', '2391', '2392', '2393', '2394', '2395', '2397', '2398', '2399', '24', '240', '2400', '2401', '2402', '2403', '2404', '2405', '2406', '2407', '2408', '2409', '241', '2410', '2411', '2413', '2414', '2415', '2416', '2417', '2418', '2419', '242', '2420', '2421', '2422', '2423', '2424', '2425', '2426', '2427', '2428', '2429', '243', '2430', '2431', '2432', '2433', '2434', '2435', '2436', '2437', '2438', '2439', '244', '2440', '2441', '2443', '2444', '2445', '2446', '2447', '2448', '2449', '245', '2450', '2451', '2452', '2453', '2454', '2455', '2456', '2457', '2458', '2459', '246', '2460', '2462', '2463', '2464', '2465', '2466', '2467', '2468', '2469', '247', '2470', '2471', '2472', '2473', '2474', '2475', '2476', '2477', '2478', '2479', '248', '2480', '2481', '2482', '2483', '2484', '2485', '2486', '2487', '2488', '2489', '249', '2490', '2491', '2492', '2493', '2494', '2496', '2497', '2498', '2499', '25', '250', '2500', '2501', '2502', '2503', '2504', '2505', '2506', '2507', '2508', '2509', '251', '2510', '2511', '2512', '2513', '2514', '2516', '2517', '2518', '2519', '252', '2520', '2521', '2522', '2523', '2524', '2525', '2526', '2527', '2528', '253', '2530', '2531', '2532', '2533', '2534', '2535', '2536', '2537', '2538', '2539', '254', '2540', '2541', '2542', '2543', '2544', '2545', '2546', '2547', '2548', '2549', '255', '2551', '2552', '2553', '2554', '2555', '2556', '2557', '2558', '2559', '256', '2560', '2561', '2562', '2563', '2564', '2565', '2569', '257', '2570', '2571', '2572', '2573', '2574', '2575', '2576', '2577', '2578', '2579', '258', '2580', '2581', '2582', '2583', '2585', '2586', '2587', '259', '2590', '2591', '2593', '2594', '2595', '2596', '2597', '2598', '2599', '26', '260', '2600', '2601', '2602', '2603', '2604', '2605', '2606', '2607', '2608', '2609', '261', '2610', '2611', '2613', '2614', '2615', '2616', '2617', '2618', '2619', '262', '2620', '2621', '2622', '2623', '2624', '2625', '2626', '2627', '2628', '2629', '263', '2630', '2631', '2632', '2633', '2634', '2635', '2636', '2637', '2638', '2639', '264', '2640', '2641', '2642', '2643', '2644', '2645', '2646', '2648', '265', '2650', '2651', '2653', '2654', '2655', '2656', '266', '2660', '2661', '2662', '2663', '2664', '2665', '2666', '2667', '2668', '2669', '267', '2670', '2671', '2672', '2673', '2674', '2675', '2676', '2677', '2678', '2679', '268', '2680', '2681', '2682', '2683', '2684', '2685', '2686', '2687', '2688', '2689', '269', '2690', '2691', '2692', '2693', '2694', '2695', '2696', '2697', '2698', '2699', '27', '270', '2700', '2701', '2702', '2703', '2704', '2705', '2706', '2707', '2708', '271', '2710', '2711', '2712', '2713', '2714', '2715', '2716', '2717', '2718', '2719', '272', '2720', '2721', '2722', '2723', '2724', '2725', '2726', '2727', '2728', '2729', '273', '2730', '2731', '2732', '2733', '2734', '2735', '2737', '2738', '274', '2740', '2741', '2743', '2744', '2745', '2746', '2747', '2748', '2749', '275', '2750', '2751', '2752', '2753', '2754', '2755', '2756', '2757', '2758', '2759', '276', '2760', '2761', '2762', '2763', '2764', '2765', '2766', '2767', '2768', '2769', '277', '2770', '2771', '2772', '2773', '2774', '2775', '2776', '2777', '2778', '2779', '278', '2780', '2781', '2782', '2783', '2784', '2785', '2786', '2787', '2788', '2789', '279', '2790', '2791', '2792', '2793', '2794', '2795', '2796', '2797', '2798', '2799', '28', '280', '2800', '2801', '2802', '2803', '2804', '2805', '2806', '2807', '2808', '2809', '281', '2810', '2811', '2812', '2813', '2814', '2815', '2816', '2817', '2818', '2819', '282', '2821', '2822', '2823', '2824', '2825', '2826', '2827', '2828', '2829', '283', '2830', '2831', '2832', '2833', '2834', '2835', '2836', '2837', '2839', '284', '2840', '2842', '2843', '2844', '2845', '2846', '2847', '2848', '2849', '285', '2850', '2851', '2852', '2853', '2854', '2855', '2856', '2857', '2858', '2859', '286', '2860', '2861', '2862', '2863', '2864', '2865', '2866', '2867', '2868', '2869', '287', '2870', '2871', '2872', '2874', '2875', '2876', '2877', '2878', '2879', '288', '2880', '2881', '2882', '2883', '2884', '2885', '2886', '2887', '2888', '2889', '289', '2890', '2891', '2892', '2893', '2894', '29', '290', '2902', '2904', '2905', '2906', '2907', '2908', '291', '2911', '2912', '2913', '2914', '2915', '2916', '2917', '2918', '2919', '292', '2920', '2921', '2922', '2923', '2925', '2926', '2927', '2928', '2929', '293', '2930', '2931', '2932', '2933', '2934', '2935', '2936', '2937', '2938', '2939', '294', '2940', '2941', '2942', '2943', '2944', '2945', '2946', '2947', '2948', '2949', '295', '2950', '2951', '2952', '2953', '2954', '2955', '2956', '2957', '2958', '2959', '296', '2960', '2961', '2962', '2963', '2964', '2965', '2966', '2967', '2968', '2969', '297', '2970', '2971', '2972', '2973', '2974', '2975', '2976', '2977', '2978', '2979', '298', '2980', '2981', '2982', '2983', '2985', '2986', '2988', '2989', '299', '2990', '2991', '2992', '2993', '2994', '2995', '2996', '2997', '2998', '2999', '30', '300', '3000', '3001', '3002', '3003', '3004', '3005', '3006', '3007', '3008', '3009', '301', '3010', '3011', '3012', '3013', '3014', '3015', '3016', '3017', '3018', '3019', '302', '3020', '3021', '3022', '3023', '3024', '3025', '3026', '3027', '3028', '3029', '303', '3030', '3031', '3032', '3033', '3034', '3035', '3036', '3037', '3038', '3039', '304', '3040', '3041', '3042', '3043', '3044', '3045', '3046', '3047', '3048', '3049', '305', '3050', '3051', '3052', '3053', '3054', '3055', '3056', '3058', '3059', '306', '3060', '3061', '3062', '3063', '3064', '3065', '3066', '3067', '3068', '3069', '307', '3070', '3071', '3072', '3073', '3074', '3075', '3076', '3077', '3078', '3079', '308', '3080', '3081', '3082', '3083', '3084', '3085', '309', '3092', '3093', '3095', '3096', '3097', '3098', '3099', '31', '310', '3100', '3101', '3102', '3103', '3104', '3105', '3106', '3107', '311', '3113', '3114', '3115', '3116', '3117', '3118', '3119', '312', '3126', '3127', '3129', '313', '3130', '3131', '3132', '3133', '3134', '3135', '3136', '3137', '3138', '3139', '314', '3140', '3141', '3142', '3143', '3145', '3147', '3149', '315', '3150', '3151', '3155', '3156', '3157', '3158', '3159', '316', '3160', '3161', '3162', '3163', '3164', '3165', '3166', '3167', '3168', '3169', '317', '3170', '3171', '3172', '3173', '3174', '3175', '3176', '3177', '3178', '3179', '318', '3180', '3181', '3182', '3183', '3184', '3185', '3187', '3188', '3189', '319', '3190', '3191', '3192', '3193', '3194', '3196', '3197', '3199', '32', '320', '3200', '3201', '3202', '3203', '3204', '3205', '3206', '3207', '3208', '3209', '321', '3210', '3211', '3212', '3213', '3214', '3215', '3216', '3217', '3218', '322', '3220', '3221', '3222', '3223', '3224', '3225', '3226', '3227', '3228', '3229', '323', '3230', '3231', '3232', '3233', '3234', '3235', '3236', '3237', '3238', '3239', '324', '3240', '3241', '3242', '3243', '3244', '3245', '3246', '3247', '3248', '3249', '325', '3250', '3251', '3253', '3254', '3256', '3257', '3258', '3259', '326', '3260', '3261', '3262', '3263', '3264', '3265', '3266', '3267', '3268', '3269', '327', '3272', '3273', '3274', '3275', '3276', '3278', '3279', '328', '3281', '3282', '3283', '3284', '3285', '3286', '3287', '3288', '3289', '329', '3290', '3291', '3292', '3293', '3294', '3295', '3296', '3297', '3298', '33', '330', '3300', '3301', '3302', '3303', '3304', '3305', '3306', '3307', '3308', '3309', '331', '3310', '3311', '3312', '3313', '3314', '3315', '3316', '3317', '3318', '332', '3320', '3321', '3323', '3324', '3326', '3327', '3328', '3329', '333', '3330', '3331', '3332', '3333', '3335', '3336', '3337', '3338', '3339', '334', '3340', '3341', '3342', '3343', '3344', '3345', '3346', '3347', '3348', '3349', '335', '3350', '3351', '3352', '3353', '3354', '3355', '3356', '3357', '3358', '3359', '336', '3360', '3361', '3362', '3363', '3364', '3365', '3366', '3367', '3368', '3369', '337', '3370', '3371', '3372', '3373', '3374', '3375', '3376', '3377', '3378', '3379', '338', '3380', '3381', '3382', '3383', '3385', '3386', '3387', '3388', '3389', '339', '3390', '3391', '3392', '3393', '3394', '3395', '3397', '3398', '34', '340', '3400', '3401', '3403', '3404', '3406', '3407', '3408', '3409', '341', '3410', '3411', '3412', '3413', '3414', '3415', '3416', '3417', '3418', '3419', '342', '3420', '3421', '3422', '3423', '3424', '3425', '3426', '3427', '3428', '3429', '343', '3431', '3432', '3433', '3434', '3435', '3436', '3437', '3438', '3439', '344', '3440', '3441', '3442', '3443', '3444', '3445', '3446', '3447', '3448', '3449', '345', '3450', '3451', '3452', '3453', '3454', '3455', '3456', '3457', '3458', '3459', '346', '3460', '3461', '3462', '3463', '3464', '3465', '3466', '3467', '3468', '347', '3471', '3472', '3473', '3474', '3476', '3477', '3479', '348', '3480', '3482', '3483', '3485', '3486', '3489', '349', '3490', '3491', '3492', '3493', '3494', '3495', '3496', '3497', '3498', '35', '350', '3500', '3501', '3502', '3504', '3505', '3507', '3508', '3509', '351', '3510', '3511', '3512', '3513', '3514', '3515', '3516', '3517', '3518', '3519', '352', '3520', '3521', '3522', '3523', '3524', '3525', '3526', '3527', '3528', '3529', '353', '3530', '3531', '3532', '3533', '3534', '3535', '3536', '3537', '3538', '3539', '354', '3540', '3541', '3542', '3543', '3544', '3545', '3546', '3547', '3548', '355', '3550', '3551', '3552', '3554', '3555', '3557', '3558', '356', '3560', '3561', '3562', '3563', '3564', '3567', '3568', '3569', '357', '3570', '3571', '3572', '3573', '3574', '3575', '3576', '3577', '3578', '358', '3580', '3581', '3582', '3583', '3584', '3585', '3586', '3587', '3588', '3589', '359', '3590', '3591', '3592', '3593', '3594', '3595', '3596', '3597', '3598', '3599', '36', '360', '3600', '3601', '3602', '3603', '3604', '3605', '3606', '3607', '3608', '3609', '361', '3610', '3611', '3612', '3613', '3614', '3615', '3616', '3617', '3618', '3619', '362', '3620', '3621', '3622', '3623', '3627', '3628', '3629', '363', '3630', '3631', '3632', '3633', '3634', '3635', '3636', '3637', '3638', '3639', '364', '3640', '3641', '3644', '3645', '3646', '3647', '3648', '3649', '365', '3650', '3651', '3652', '3653', '3654', '3655', '3656', '3657', '3658', '3659', '366', '3660', '3661', '3664', '3665', '3666', '3667', '3668', '3669', '367', '3670', '3671', '3672', '3673', '3674', '3675', '3676', '3677', '3678', '3679', '368', '3680', '3681', '3682', '3683', '3684', '3685', '3686', '3687', '3688', '3689', '369', '3690', '3691', '3692', '3693', '3694', '3695', '3696', '3697', '3698', '3699', '37', '370', '3700', '3701', '3702', '3703', '3704', '3705', '3706', '3707', '3709', '371', '3710', '3711', '3715', '3716', '3717', '3718', '3719', '372', '3720', '3721', '3722', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '373', '3730', '3731', '3732', '3734', '3735', '3736', '3737', '3738', '3739', '374', '3740', '3741', '3742', '3743', '3744', '3745', '3746', '3747', '3748', '3749', '375', '3750', '3751', '3752', '3753', '3754', '3755', '3756', '3757', '3758', '3759', '376', '3760', '3761', '3762', '3763', '3764', '3765', '3766', '3767', '3768', '377', '3770', '3771', '3772', '3773', '3774', '3775', '3776', '3777', '3778', '3779', '378', '3780', '3781', '3782', '3783', '3784', '3785', '3786', '3788', '3789', '379', '3790', '3791', '3792', '3793', '3794', '3795', '3796', '3797', '3798', '3799', '38', '380', '3800', '3801', '3802', '3803', '3804', '3805', '3806', '3807', '3808', '3809', '381', '3810', '3811', '3812', '3813', '3814', '3816', '3817', '3818', '3819', '382', '3820', '3821', '3822', '3823', '3824', '3825', '3827', '3828', '3829', '383', '3830', '3831', '3832', '3833', '3834', '3835', '3836', '3837', '3838', '384', '3840', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3849', '385', '3851', '3852', '3853', '3854', '3855', '3857', '3858', '3859', '386', '3860', '3861', '3862', '3863', '3864', '3865', '3866', '3867', '3868', '3869', '387', '3870', '3871', '3872', '3873', '3874', '3875', '3876', '3877', '3878', '3879', '388', '3880', '3881', '3883', '3884', '3885', '3886', '3887', '3888', '3889', '389', '3890', '3891', '3894', '3895', '3896', '3898', '3899', '39', '390', '3900', '3901', '3902', '3903', '3904', '3905', '3906', '3907', '3908', '3909', '391', '3910', '3911', '3912', '3913', '3914', '3915', '3916', '3917', '3918', '3919', '392', '3920', '3921', '3922', '3923', '3924', '3925', '3926', '3927', '3928', '3929', '393', '3930', '3931', '3932', '3933', '3934', '3935', '3936', '3937', '3938', '3939', '394', '3940', '3941', '3942', '3943', '3944', '3945', '3947', '3949', '395', '3950', '3951', '3952', '3953', '3954', '3955', '3956', '3957', '3958', '3959', '396', '3960', '3961', '3962', '3963', '3964', '3965', '3966', '3967', '397', '3972', '3973', '3974', '3975', '3976', '3977', '3978', '3979', '398', '3980', '3981', '3982', '3983', '3984', '3985', '3987', '3989', '399', '3990', '3991', '3993', '3994', '3997', '3998', '40', '400', '4006', '4007', '4008', '401', '4010', '4011', '4013', '4014', '4015', '4016', '4017', '4018', '4019', '402', '4020', '4021', '4023', '4024', '4025', '4026', '4027', '4028', '4029', '403', '4030', '4031', '4032', '4033', '4034', '4035', '4036', '4037', '4038', '4039', '404', '4040', '4041', '4043', '4044', '4045', '4046', '4047', '4048', '4049', '405', '4050', '4051', '4052', '4053', '4054', '4055', '4056', '4057', '4058', '4059', '406', '4060', '4061', '4063', '4064', '4065', '4066', '4067', '4068', '4069', '407', '4070', '4071', '4072', '4073', '4075', '4076', '4077', '4078', '4079', '408', '4080', '4081', '4082', '4083', '4084', '4085', '4086', '4087', '4088', '4089', '409', '4090', '4091', '4092', '4093', '4094', '4095', '4098', '4099', '41', '410', '4100', '4101', '4102', '4103', '4104', '4105', '4106', '4107', '4108', '4109', '411', '4110', '4111', '4112', '4113', '4114', '4115', '4116', '4117', '4118', '4119', '412', '4120', '4121', '4122', '4123', '4124', '4125', '4126', '4127', '4129', '413', '4130', '4131', '4132', '4134', '4135', '4136', '4137', '4138', '4139', '414', '4140', '4141', '4142', '4143', '4144', '4145', '4146', '4147', '4148', '4149', '415', '4150', '4152', '4153', '4154', '4155', '4156', '4158', '4159', '416', '4160', '4161', '4162', '4163', '4167', '4168', '4169', '417', '4172', '4173', '4174', '4175', '4176', '4177', '4178', '4179', '418', '4180', '4181', '4182', '4183', '4184', '4185', '4186', '4187', '4189', '419', '4190', '4191', '4192', '4193', '4194', '4195', '4196', '4197', '4198', '4199', '42', '420', '4200', '4201', '4202', '4203', '4204', '4205', '4206', '4207', '4208', '4209', '421', '4210', '4211', '4212', '4213', '4214', '4215', '4216', '4217', '4218', '4219', '422', '4220', '4221', '4222', '4223', '4224', '4225', '4226', '4227', '4228', '4229', '423', '4230', '4231', '4232', '4233', '4234', '4235', '4236', '4237', '4238', '4239', '424', '4240', '4241', '4242', '4243', '4244', '4245', '4246', '4247', '4248', '4249', '4250', '4251', '4252', '4253', '4254', '4255', '4256', '4257', '4258', '4259', '4260', '4261', '4263', '4264', '4265', '4266', '4267', '4268', '4269', '427', '4272', '4273', '4274', '4275', '4276', '4277', '4278', '4279', '4280', '4281', '4282', '4283', '4284', '4285', '4286', '4287', '4288', '4289', '4290', '4291', '4292', '4293', '4294', '4295', '4296', '4297', '4298', '4299', '43', '4300', '4301', '4302', '4303', '4304', '4305', '4306', '4307', '4308', '4309', '4310', '4311', '4313', '4314', '4315', '4316', '4317', '4318', '4319', '4320', '4321', '4322', '4323', '4324', '4325', '4326', '4327', '4328', '4329', '4330', '4331', '4332', '4333', '4334', '4335', '4336', '4337', '4338', '4339', '4340', '4341', '4342', '4343', '4344', '4345', '4346', '4347', '4348', '4349', '4350', '4351', '4352', '4353', '4354', '4355', '4356', '4357', '4358', '4359', '4360', '4361', '4363', '4364', '4365', '4366', '4367', '4368', '4369', '4370', '4371', '4372', '4373', '4374', '4375', '4376', '4377', '4378', '4379', '4380', '4381', '4382', '4383', '4384', '4385', '4386', '4387', '4388', '4389', '4390', '4391', '4393', '4394', '4395', '4397', '4398', '4399', '44', '4400', '4401', '4402', '4404', '4406', '4407', '4408', '4410', '4411', '4412', '4413', '4414', '4415', '4416', '4417', '4418', '4419', '4420', '4421', '4423', '4424', '4425', '4426', '4427', '4428', '4429', '4430', '4431', '4432', '4433', '4434', '4435', '4436', '4437', '4438', '4439', '4440', '4441', '4442', '4443', '4444', '4445', '4446', '4447', '4448', '4449', '445', '4450', '4451', '4452', '4453', '4454', '4455', '4456', '4457', '4458', '4459', '446', '4460', '4461', '4462', '4463', '4464', '4465', '4469', '447', '4472', '4473', '4474', '4475', '4477', '4478', '4479', '448', '4480', '4481', '4483', '4484', '4485', '4486', '4487', '4488', '4489', '449', '4490', '4491', '4492', '4493', '4495', '4496', '4497', '4498', '4499', '45', '4500', '4502', '4503', '4504', '4505', '4507', '4508', '4509', '451', '4510', '4512', '4513', '4514', '4515', '4516', '4517', '4518', '4519', '452', '4520', '4521', '4522', '4523', '4524', '4525', '4526', '4527', '4528', '4529', '453', '4530', '4531', '4532', '4534', '4535', '4537', '4538', '4539', '454', '4540', '4541', '4543', '4544', '4545', '4546', '4547', '4548', '4549', '4550', '4551', '4552', '4553', '4554', '4555', '4556', '4557', '4558', '4559', '456', '4560', '4561', '4562', '4563', '4564', '4565', '4566', '4567', '4568', '4569', '457', '4570', '4571', '4572', '4573', '4574', '4575', '4576', '4577', '4578', '4579', '458', '4580', '4581', '4582', '4583', '4584', '4585', '4586', '4587', '4588', '4589', '459', '4590', '4591', '4592', '4593', '4594', '4595', '4596', '46', '460', '4601', '4602', '4603', '4604', '4605', '4606', '4607', '4608', '4609', '461', '4610', '4611', '4612', '4613', '4614', '4615', '4616', '4617', '4618', '4619', '4620', '4621', '4622', '4623', '4624', '4625', '4626', '4627', '4628', '4629', '4630', '4631', '4632', '4633', '4634', '4635', '4636', '4637', '4638', '4639', '464', '4640', '4641', '4642', '4643', '4644', '4645', '4646', '465', '4651', '4652', '4653', '4654', '4655', '4656', '4657', '466', '4660', '4661', '4662', '4663', '4664', '4665', '4666', '4667', '4668', '4669', '467', '4670', '4671', '4672', '4673', '4674', '4675', '4676', '4677', '4678', '468', '469', '47', '470', '471', '472', '473', '474', '475', '476', '477', '478', '479', '48', '480', '481', '482', '483', '484', '485', '486', '487', '488', '489', '49', '490', '491', '492', '493', '494', '495', '496', '497', '498', '499', '50', '500', '501', '502', '503', '504', '505', '506', '507', '508', '509', '51', '510', '511', '512', '513', '514', '515', '516', '517', '518', '519', '52', '520', '521', '522', '523', '524', '525', '526', '527', '528', '529', '53', '530', '531', '532', '533', '534', '535', '536', '537', '538', '539', '54', '540', '541', '542', '543', '544', '545', '546', '547', '548', '549', '55', '550', '551', '552', '553', '554', '555', '556', '557', '558', '559', '56', '560', '561', '562', '563', '564', '565', '566', '567', '568', '569', '57', '570', '571', '572', '573', '574', '575', '576', '577', '578', '579', '58', '580', '581', '582', '583', '584', '585', '586', '587', '588', '589', '59', '590', '591', '592', '593', '594', '595', '596', '597', '598', '599', '60', '600', '601', '602', '603', '604', '605', '606', '607', '608', '609', '61', '610', '611', '612', '613', '614', '615', '616', '617', '618', '619', '62', '620', '621', '622', '623', '624', '625', '626', '627', '628', '629', '63', '630', '631', '632', '633', '634', '635', '636', '637', '638', '639', '64', '640', '641', '642', '643', '644', '645', '646', '647', '648', '649', '65', '650', '651', '652', '653', '654', '655', '656', '657', '658', '659', '66', '660', '661', '662', '663', '664', '665', '666', '667', '668', '669', '67', '671', '672', '673', '674', '675', '676', '677', '678', '679', '68', '680', '681', '682', '683', '684', '685', '686', '687', '688', '689', '69', '690', '691', '692', '693', '694', '695', '696', '697', '698', '699', '7', '70', '700', '708', '709', '71', '710', '72', '721', '722', '723', '724', '725', '726', '727', '728', '729', '73', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '74', '740', '741', '742', '743', '744', '745', '746', '747', '75', '750', '751', '76', '762', '763', '765', '767', '768', '769', '77', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '78', '780', '781', '782', '785', '786', '787', '788', '789', '79', '790', '791', '792', '793', '794', '795', '796', '797', '798', '799', '8', '80', '800', '801', '802', '803', '804', '805', '806', '807', '808', '809', '81', '810', '811', '812', '813', '814', '815', '816', '817', '818', '819', '82', '820', '821', '822', '823', '824', '825', '826', '827', '828', '829', '83', '830', '831', '832', '833', '834', '835', '836', '837', '838', '839', '84', '840', '841', '842', '843', '844', '845', '846', '847', '848', '849', '85', '850', '851', '852', '853', '854', '855', '856', '857', '858', '859', '86', '860', '861', '862', '863', '864', '865', '866', '867', '868', '869', '87', '871', '872', '873', '874', '875', '876', '877', '878', '879', '88', '880', '881', '882', '883', '884', '885', '886', '887', '888', '889', '89', '890', '891', '892', '893', '894', '895', '896', '897', '898', '899', '9', '90', '900', '901', '902', '903', '904', '905', '906', '907', '908', '909', '91', '910', '911', '912', '913', '914', '915', '916', '917', '918', '919', '92', '920', '921', '922', '923', '924', '925', '926', '927', '928', '929', '93', '930', '931', '932', '933', '934', '935', '936', '937', '938', '939', '94', '940', '941', '942', '943', '944', '945', '946', '947', '948', '949', '95', '950', '951', '952', '953', '954', '955', '956', '957', '958', '959', '96', '960', '961', '962', '963', '964', '965', '966', '967', '968', '969', '970', '971', '972', '973', '975', '976', '977', '978', '979', '98', '980', '981', '982', '983', '984', '985', '986', '987', '988', '989', '99', '990', '991', '992', '993', '994', '995', '996', '998', '999') AND idx.itemID NOT IN ('10', '1002', '1005', '1008', '101', '1011', '1014', '1017', '1020', '1023', '1024', '1027', '1030', '1034', '1036', '1040', '1043', '1046', '1049', '105', '1052', '1055', '1058', '1061', '1064', '1067', '1070', '1073', '1076', '1079', '108', '1082', '1085', '1088', '1093', '1098', '1101', '1104', '1107', '111', '1110', '1115', '1118', '1121', '1124', '1127', '1130', '1131', '1136', '114', '1140', '1144', '1147', '1150', '1153', '1155', '1158', '1161', '1164', '1169', '117', '1172', '1175', '1178', '1181', '1184', '1187', '1190', '1193', '1196', '1199', '120', '1202', '1205', '1208', '1213', '1216', '1220', '1223', '1226', '1229', '123', '1232', '1235', '1238', '1241', '1244', '1247', '1250', '1253', '1256', '126', '1260', '1263', '1266', '1269', '1272', '1275', '1278', '1281', '1284', '1287', '129', '1290', '1293', '1296', '1299', '13', '1302', '1305', '1308', '1311', '1314', '1317', '132', '1320', '1323', '1324', '1333', '1334', '1335', '1336', '1338', '1341', '1346', '1347', '135', '1350', '1353', '1356', '1359', '1362', '1365', '1368', '1371', '1374', '1375', '1376', '1377', '1378', '138', '1381', '1386', '1389', '1390', '1391', '1393', '1396', '1399', '1402', '1405', '1408', '141', '1411', '1414', '1417', '1418', '1421', '1424', '1425', '1426', '1429', '1432', '1435', '144', '1446', '1447', '1454', '1457', '1460', '1463', '1466', '1469', '147', '1472', '1475', '1478', '1481', '1484', '1487', '1490', '1493', '1496', '1497', '1498', '150', '1501', '1504', '1505', '1506', '1507', '1508', '1509', '1510', '1511', '1514', '1517', '1520', '1523', '1526', '1529', '153', '1532', '1535', '1538', '1542', '1543', '1546', '1549', '1552', '1557', '156', '1560', '1563', '1566', '1569', '1572', '1575', '1578', '1581', '1584', '1587', '159', '1590', '1593', '1596', '1599', '16', '1602', '1605', '1608', '1611', '1614', '1618', '162', '1621', '1624', '1627', '1630', '1633', '1636', '1637', '1638', '1641', '1644', '1647', '165', '1650', '1653', '1656', '1659', '1662', '1665', '1668', '1671', '1674', '1677', '168', '1680', '1683', '1686', '1689', '1692', '1695', '1698', '1701', '1704', '1707', '171', '1710', '1713', '1716', '1719', '1722', '1725', '1728', '1729', '1732', '1735', '1738', '174', '1741', '1744', '1747', '1752', '1755', '1766', '177', '1771', '1774', '1777', '1780', '1781', '1786', '1789', '1792', '1799', '180', '1802', '1805', '1808', '1813', '1818', '1819', '1822', '1827', '183', '1832', '1837', '1842', '1845', '1850', '1855', '1858', '186', '1861', '1864', '1867', '1870', '1874', '1875', '1880', '1885', '1886', '189', '1891', '1894', '1897', '19', '1900', '1903', '1904', '1907', '1910', '1913', '1916', '1919', '192', '1922', '1925', '1928', '1931', '1934', '1937', '1940', '1943', '1946', '195', '1951', '1954', '1957', '1960', '1963', '1966', '1969', '1974', '1979', '198', '1982', '1985', '1988', '1991', '1994', '1997', '2000', '2003', '2008', '201', '2013', '2016', '2021', '2024', '2027', '2030', '2033', '2036', '2039', '204', '2042', '2045', '2048', '2051', '2054', '2057', '2060', '2061', '2064', '2067', '207', '2070', '2073', '2076', '2079', '208', '2082', '2085', '2088', '2091', '2094', '2097', '2098', '2099', '2100', '2101', '2104', '2107', '2108', '211', '2111', '2114', '2117', '2120', '2123', '2126', '2129', '2132', '2135', '2136', '2139', '214', '2142', '2145', '2146', '2147', '2148', '2151', '2154', '2157', '2160', '2163', '2166', '2169', '217', '2172', '2175', '2178', '2181', '2182', '2183', '2184', '2185', '2186', '2187', '2188', '2189', '2190', '2193', '2196', '2199', '22', '220', '2202', '2205', '2208', '2213', '2216', '2219', '2222', '2225', '2226', '2229', '223', '2232', '2235', '2236', '2237', '2238', '2241', '2244', '2247', '2250', '2253', '2256', '2259', '226', '2262', '2265', '2268', '2271', '2274', '2277', '2280', '2283', '2286', '2289', '229', '2292', '2293', '2294', '2295', '2296', '2297', '2298', '2301', '2302', '2303', '2304', '2305', '2306', '2307', '2310', '2313', '2316', '2319', '232', '2322', '2325', '2331', '2332', '2333', '2334', '2335', '2336', '2337', '2338', '2339', '2340', '2343', '2348', '235', '2351', '2354', '2357', '2360', '2363', '2366', '2369', '2372', '2375', '2378', '238', '2381', '2384', '2387', '2390', '2393', '2396', '2399', '2402', '2403', '2406', '2409', '241', '2412', '2415', '2418', '2421', '2424', '2427', '2430', '2433', '2436', '2439', '244', '2442', '2445', '2448', '2451', '2454', '2457', '2460', '2461', '2462', '2465', '2468', '247', '2471', '2474', '2477', '2480', '2483', '2486', '2489', '2492', '2495', '2498', '25', '250', '2501', '2504', '2507', '2510', '2513', '2517', '2520', '2523', '2526', '2529', '253', '2532', '2535', '2538', '2541', '2544', '2547', '2550', '2553', '2556', '2559', '256', '2562', '2565', '2566', '2569', '2572', '2575', '2578', '2581', '2584', '2585', '2588', '2589', '259', '2592', '2595', '2596', '2601', '2606', '2609', '2612', '2615', '2618', '262', '2621', '2624', '2627', '2630', '2633', '2636', '2639', '2642', '2647', '265', '2652', '2657', '2658', '2659', '2664', '2667', '2670', '2673', '2676', '2679', '268', '2682', '2685', '2688', '2691', '2694', '2697', '2700', '2703', '2706', '2709', '2712', '2715', '2718', '2721', '2724', '2727', '273', '2730', '2733', '2736', '2739', '2742', '2743', '2744', '2745', '2748', '2751', '2754', '2757', '276', '2760', '2763', '2766', '2769', '2772', '2775', '2778', '2779', '2782', '2785', '2788', '2793', '2796', '2799', '28', '2802', '2805', '2808', '281', '2811', '2814', '2815', '2816', '2817', '2820', '2821', '2822', '2825', '2828', '2831', '2834', '2837', '284', '2840', '2843', '2847', '2850', '2853', '2856', '2859', '2862', '2863', '2866', '2867', '287', '2870', '2873', '2874', '2877', '2878', '2879', '2880', '2883', '2884', '2885', '2889', '2892', '2895', '2896', '2897', '2898', '2899', '290', '2900', '2901', '2902', '2905', '2909', '2910', '2911', '2915', '2918', '2922', '2923', '2924', '2927', '293', '2930', '2931', '2934', '2937', '2940', '2943', '2946', '2949', '2952', '2955', '2958', '296', '2961', '2964', '2967', '2970', '2971', '2974', '2977', '2978', '2981', '2984', '2987', '299', '2990', '2993', '2996', '2999', '3002', '3005', '3006', '3007', '3008', '3011', '3014', '3015', '3016', '3017', '3018', '3019', '302', '3020', '3021', '3022', '3023', '3024', '3025', '3026', '3029', '3032', '3035', '3038', '3041', '3044', '3045', '3048', '3051', '3054', '3057', '3060', '3063', '3066', '3069', '307', '3072', '3075', '3078', '3079', '3080', '3081', '3082', '3083', '3084', '3085', '3086', '3087', '3088', '3089', '3090', '3091', '3092', '3093', '3094', '3095', '3096', '3099', '31', '310', '3102', '3105', '3106', '3107', '3110', '3111', '3112', '3113', '3116', '3119', '3128', '313', '3131', '3134', '3137', '3140', '3141', '3142', '3143', '3144', '3145', '3147', '3148', '3149', '3154', '3155', '3156', '3159', '316', '3162', '3163', '3164', '3165', '3166', '3169', '3172', '3173', '3174', '3175', '3176', '3179', '3182', '3185', '3186', '3189', '3190', '3191', '3192', '3195', '3198', '3201', '3204', '3205', '3206', '3209', '321', '3216', '3219', '3222', '3225', '3228', '3231', '3234', '3237', '324', '3240', '3243', '3246', '3249', '3252', '3255', '3258', '3261', '3264', '3267', '327', '3270', '3271', '3276', '3277', '3280', '3285', '3288', '3293', '3296', '3299', '330', '3300', '3303', '3306', '3309', '3312', '3313', '3314', '3315', '3316', '3317', '3318', '3319', '3322', '3325', '3328', '333', '3331', '3334', '3337', '3340', '3343', '3346', '3349', '3352', '3353', '3354', '3355', '3358', '336', '3361', '3364', '3365', '3368', '3371', '3372', '3373', '3374', '3377', '3378', '3379', '3382', '3383', '3384', '3385', '3386', '3387', '339', '3390', '3393', '3396', '3399', '34', '3402', '3405', '3408', '3411', '3414', '3417', '342', '3420', '3423', '3426', '3429', '3430', '3431', '3432', '3433', '3434', '3435', '3436', '3437', '3438', '3439', '3440', '3441', '3442', '3443', '3444', '3445', '3448', '3449', '345', '3452', '3453', '3454', '3455', '3456', '3459', '3460', '3463', '3466', '3469', '3470', '3473', '3474', '3475', '3478', '348', '3481', '3484', '3487', '3488', '3489', '3490', '3491', '3494', '3495', '3496', '3497', '3498', '3499', '3500', '3503', '3506', '3509', '351', '3512', '3515', '3516', '3517', '3518', '3519', '3520', '3523', '3526', '3529', '3532', '3535', '3538', '3539', '354', '3540', '3543', '3546', '3550', '3551', '3552', '3553', '3554', '3555', '3556', '3559', '3562', '3565', '3566', '3567', '3568', '3569', '357', '3575', '3576', '3579', '3582', '3585', '3588', '360', '3605', '3608', '3609', '3610', '3611', '3612', '3613', '3616', '3617', '3620', '3623', '3624', '3625', '3626', '3627', '3628', '3629', '363', '3632', '3638', '3641', '3644', '3645', '3648', '3651', '3658', '366', '3661', '3662', '3663', '3664', '3665', '3666', '3669', '3670', '3671', '3674', '3677', '3680', '3683', '3686', '3689', '369', '3692', '3693', '3696', '3699', '37', '3702', '3705', '3708', '3711', '3712', '3715', '372', '3724', '3727', '3730', '3733', '3736', '3739', '3740', '3743', '3746', '3747', '3748', '3749', '375', '3750', '3751', '3754', '3757', '3758', '3761', '3764', '3765', '3768', '3769', '3770', '3771', '3772', '3775', '3776', '3779', '378', '3780', '3783', '3786', '3787', '3790', '3793', '3796', '3797', '3798', '3801', '3804', '3807', '3808', '3809', '381', '3810', '3815', '3818', '3821', '3823', '3826', '3827', '3828', '3831', '3834', '3835', '3836', '3837', '3838', '3839', '3840', '3843', '3846', '3849', '3850', '3853', '3855', '3857', '3858', '386', '3861', '3862', '3863', '3864', '3865', '3866', '3868', '3869', '3873', '3875', '3877', '3880', '3882', '3885', '3888', '389', '3890', '3894', '3895', '3899', '3902', '3905', '3908', '3909', '3912', '3915', '3918', '392', '3921', '3924', '3925', '3926', '3927', '3930', '3933', '3936', '3939', '394', '3940', '3941', '3944', '3945', '3946', '3947', '3948', '3949', '3950', '3951', '3952', '3953', '3954', '3955', '3956', '3959', '3960', '3961', '3962', '3965', '3966', '3967', '3968', '3969', '3970', '3971', '3972', '3973', '3976', '3979', '3980', '3981', '3982', '3983', '3984', '3985', '3986', '3987', '3988', '3989', '3990', '3991', '3992', '3993', '3994', '3995', '3996', '3999', '40', '4000', '4001', '4002', '4003', '4004', '4005', '4006', '4009', '4010', '4011', '4012', '4013', '4014', '4015', '4022', '4025', '4026', '4027', '4028', '4031', '4032', '4033', '4036', '4039', '4040', '4041', '4042', '4043', '4049', '4052', '4055', '4056', '4057', '4058', '4059', '4062', '4065', '4068', '4071', '4074', '4077', '4080', '4083', '4086', '4089', '4092', '4095', '4098', '4101', '4104', '4107', '4108', '4109', '4110', '4111', '4114', '4115', '4116', '4118', '4122', '4124', '4126', '4128', '4129', '4131', '4133', '4134', '4135', '4136', '4137', '4138', '4139', '4140', '4141', '4142', '4145', '4148', '4151', '4154', '4157', '4158', '4159', '4160', '4161', '4162', '4163', '4172', '4174', '4175', '4176', '4177', '4178', '4179', '4182', '4185', '4188', '4191', '4194', '4197', '4200', '4203', '4205', '4207', '4210', '4213', '4216', '4219', '4221', '4223', '4224', '4227', '4228', '4229', '4230', '4231', '4232', '4234', '4237', '4240', '4243', '4246', '4249', '425', '4250', '4251', '4252', '4254', '4255', '4256', '4257', '4259', '4260', '4261', '4262', '4266', '4269', '427', '4270', '4271', '4274', '4275', '4276', '4277', '4278', '4279', '428', '4280', '4281', '4282', '4283', '4288', '429', '4291', '4294', '4297', '4298', '4299', '43', '430', '4300', '4301', '4302', '4303', '4304', '4307', '4308', '4309', '431', '4310', '4311', '4312', '4313', '4314', '4315', '4316', '4317', '4318', '4319', '432', '4320', '4321', '4322', '433', '4333', '434', '435', '436', '4362', '4363', '4368', '4369', '437', '4371', '4372', '4373', '4374', '4377', '438', '4383', '4385', '4386', '4387', '4388', '4389', '439', '4390', '4392', '4395', '4397', '4398', '4399', '440', '4400', '4404', '4406', '4407', '4408', '4409', '441', '4410', '4413', '4416', '4419', '442', '4422', '4425', '4427', '443', '4430', '4431', '4434', '4435', '4436', '4438', '4439', '444', '4440', '4441', '4442', '4443', '4444', '4445', '4446', '4447', '4448', '4449', '445', '4450', '4453', '4456', '4459', '446', '4462', '4465', '4466', '4467', '4468', '4469', '447', '4470', '4471', '4472', '4473', '4474', '4475', '4476', '4477', '4478', '448', '4481', '4482', '4485', '4486', '4487', '4488', '4489', '449', '4490', '4491', '4492', '4493', '4494', '4497', '4498', '4499', '450', '4500', '4501', '4502', '4503', '4506', '4507', '4508', '451', '4511', '4515', '4518', '4521', '4524', '4527', '4530', '4533', '4536', '4539', '4542', '4545', '4546', '4547', '4548', '4549', '455', '4552', '4553', '4556', '4559', '456', '4560', '4561', '4564', '4567', '4568', '4571', '4574', '4577', '4580', '4583', '4584', '4585', '4588', '459', '4591', '4594', '4596', '46', '4601', '4602', '4603', '4604', '4607', '4610', '4613', '4617', '462', '4621', '4622', '4625', '4628', '463', '4632', '4635', '4639', '464', '4642', '4645', '4646', '4647', '4648', '4649', '4650', '4651', '4652', '4653', '4654', '4658', '4659', '4660', '4661', '4662', '4663', '4666', '4667', '4668', '4670', '4671', '4672', '4673', '4674', '4675', '4676', '4677', '4678', '479', '482', '485', '49', '490', '496', '499', '502', '505', '506', '513', '516', '519', '52', '522', '525', '528', '531', '534', '537', '540', '543', '548', '55', '552', '555', '558', '561', '564', '570', '573', '576', '579', '58', '582', '585', '588', '591', '598', '601', '604', '607', '61', '610', '613', '616', '619', '622', '625', '628', '631', '634', '64', '640', '641', '646', '649', '653', '656', '659', '661', '667', '67', '670', '671', '674', '677', '680', '683', '686', '689', '692', '695', '698', '7', '70', '701', '702', '703', '704', '705', '706', '707', '711', '712', '713', '714', '715', '716', '717', '718', '719', '720', '721', '722', '727', '73', '730', '733', '736', '739', '742', '745', '748', '749', '752', '753', '754', '755', '756', '757', '758', '759', '76', '760', '761', '762', '763', '764', '765', '766', '767', '770', '773', '783', '785', '786', '789', '79', '792', '795', '798', '801', '804', '807', '810', '813', '816', '819', '82', '822', '825', '828', '831', '834', '837', '840', '843', '846', '849', '85', '852', '855', '858', '861', '864', '867', '870', '873', '876', '879', '88', '882', '885', '888', '891', '894', '897', '900', '905', '91', '910', '919', '922', '925', '928', '931', '934', '937', '94', '940', '943', '946', '949', '952', '955', '958', '961', '964', '967', '971', '974', '977', '98', '980', '985', '988', '991', '994', '997') WHERE 1=1 AND ((idx.indexKey='parentID' AND idx.indexValue=4025)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
1783472620.71750.1333Using template: /templates/shop/products/product_variant_list.html
1783472620.71770.0002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
1783472620.71850.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
1783472620.71910.0005 [7] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783472620.72110.002 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.72180.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472620.72430.0025 [6] Using template: /templates/navigation/footer-nav.html
1783472620.72530.001 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783472620.72590.0006 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783472620.73630.0104 [38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
1783472620.73980.0034 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.74050.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472620.7430.0025 [10] Using template: /templates/navigation/footer-nav.html
1783472620.7450.002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
1783472620.74560.0006 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
1783472620.74610.0005 [30] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783472620.74920.0031 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.74990.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472620.75290.003 [29] Using template: /templates/navigation/footer-nav.html
1783472620.75540.0025 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783472620.7560.0006 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783472620.75640.0005 [11] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783472620.7590.0026 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472620.75960.0006 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472620.76190.0023 [10] Using template: /templates/navigation/footer-nav.html
1783472620.76320.0013Request time: 0.5773
1783472620.76320Process time: 0.5771
1783472620.76320Memory: 2.2832