Where to Watch Birds in Surrey and Sussex

£25.99

Where to Watch Birds in Surrey and Sussex

By Matt Phelps (Sussex Wildlife Trust Species Recovery Officer) and Ed Stubbs

This site guide covers the counties of East Sussex, West Sussex and Surrey, including sites in southwest Greater London.

From the heaths of Surrey to the chalky grassland of the North and South Downs, the great forests of the Weald and the headlands, shingle beaches and river valleys of England's south coast, these three counties are a bird-rich part of the country, with perhaps the most diverse range of habitats in the country, and all within easy distance of London, the southwest part of which contains birding sites such as Barnes wetland centre.

This new book by Matthew Phelps and Ed Stubbs is the definitive guide to the birding highlights of the region. It contains a comprehensive review of all the major sites, and many lesser-known ones, with maps, notes on access, and information on target species and when to visit. Where to Watch Birds in Surrey and Sussex is indispensable for any birder heading to this bird-rich region.

Paperback

Where to Watch Birds in Surrey and Sussex example page
Where to Watch Birds in Surrey and Sussex example page - click to view larger
Time Δ Debug Message - Perch Runway 3.2
1783472499.0340 [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
1783472499.08190.0479Matched route: shop/products/[slug:s]
1783472499.08210.0003Server address: 216.73.217.142
1783472499.08220.0001Using master page: /templates/pages/shop/product.php
1783472499.08220Page arguments: 
Array
(
    [0] => /shop/products/where-to-watch-birds-in-surrey-and-sussex
    [s] => where-to-watch-birds-in-surrey-and-sussex
    [1] => where-to-watch-birds-in-surrey-and-sussex
)
1783472499.08260.0003 [1] SELECT * FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.08380.0012 [86] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
1783472499.08670.0029 [1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
1783472499.08760.0008INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
1783472499.090.0025 [1] SELECT * FROM swt_shop_cart WHERE cartID=22759237
1783472499.09070.0007 [1] SELECT * FROM swt_shop_cart WHERE cartID=22759237
1783472499.09150.0008 [nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2026-07-08 01:01:00' AND saleTo>'2026-07-08 01:01:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
1783472499.09270.0012 [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='where-to-watch-birds-in-surrey-and-sussex')) 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
1783472499.13530.0426Using template: /templates/shop/products/product.html
1783472499.13550.0002 [162] SELECT catID, catPath FROM swt_categories
1783472499.13770.0022 [250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
1783472499.13930.0016Using template: /templates/pages/attributes/seo.html
1783472499.13970.0004 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/shop/products' OR regionPage='*')
1783472499.14050.0008 [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
1783472499.1420.0015 [82] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1783472499.14490.0029 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.14550.0006 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472499.14750.002Using template: /templates/navigation/ps_nav_template.html
1783472499.14760 [6] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.14830.0007 [4] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.14870.0004 [29] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.15150.0028 [10] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.15260.0011 [7] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.15330.0008 [9] Using template: /templates/navigation/ps_nav_template_children.html
1783472499.15620.0029 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' OR pageSortPath='/shop/products' LIMIT 1
1783472499.15720.001 [1] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition
1783472499.15950.0023 [1] Using template: /templates/navigation/breadcrumbs.html
1783472499.15990.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='where-to-watch-birds-in-surrey-and-sussex')) 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
1783472499.18960.0297 [1] Using template: /templates/shop/products/product.html
1783472499.19020.0006 [1] SELECT * FROM swt_categories ORDER BY catTreePosition ASC
1783472499.19560.0054 [1] SELECT * FROM swt_shop_currencies WHERE currencyID=47 LIMIT 1
1783472499.19720.0016 [1] SELECT * FROM swt_shop_products WHERE productSlug='where-to-watch-birds-in-surrey-and-sussex' AND productDeleted IS NULL LIMIT 1
1783472499.21050.0133 [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
1783472499.28810.0776 [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
1783472499.35870.0706 [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=4178)) 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
1783472499.4570.0983Using template: /templates/shop/products/product_variant_list.html
1783472499.45720.0003 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
1783472499.45820.001 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
1783472499.4590.0008 [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
1783472499.46120.0022 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.46170.0005 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472499.46340.0017 [6] Using template: /templates/navigation/footer-nav.html
1783472499.46440.001 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783472499.46490.0005 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783472499.46520.0004 [38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
1783472499.46790.0026 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.46850.0006 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472499.47040.0019 [10] Using template: /templates/navigation/footer-nav.html
1783472499.47360.0032 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
1783472499.47440.0009 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
1783472499.47490.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
1783472499.4770.0021 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.47750.0005 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472499.47930.0018 [29] Using template: /templates/navigation/footer-nav.html
1783472499.48160.0024 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1783472499.48220.0005 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1783472499.48330.0012 [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
1783472499.48520.0019 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/shop/products' LIMIT 1
1783472499.48590.0007 [2] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-010-002', '000-010', '000') ORDER BY pageTreePosition DESC
1783472499.48770.0018 [10] Using template: /templates/navigation/footer-nav.html
1783472499.48920.0016Request time: 0.4566
1783472499.48930Process time: 0.4564
1783472499.48930Memory: 2.2829