Changeset 335
- Timestamp:
- Nov 5, 2006, 4:40:20 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/perllib/NPEMap/Postcodes.pm
r333 r335 95 95 my $sql = <<EOF; 96 96 SELECT d.outward, d.district, d.county FROM districts AS d LEFT OUTER JOIN postcodes AS p ON (d.outward = p.outward) 97 WHERE p.id IS NULL 97 WHERE p.id IS NULL AND d.county NOT IN 98 ('Northern Ireland', 'All counties', 'Aberdeenshire', 99 'Banffshire, Aberdeenshire', 'Dumfriesshire', 'Kirkcudbrightshire', 100 'Wigtownshire', 'Midlothian', 'West Lothian', 'East Lothian', 101 'Peeblesshire', 'Stirlingshire', 'Clackmannanshire', 'Perthshire', 102 'Dunbartonshire', 'Inverness', 'Ross', 'Morayshire', 'Isle of Skye', 103 'Ayrshire', 'Isle of Arran', 'Isle of Cumbrae', 'Caithness', 'Orkney', 104 'Orkney Islands', 'Fife', 'Lanarkshire', 'Renfrewshire', 'Bute', 105 'Argyllshire', 'Angus & Argyllshire', 'Inverness & Argyllshire', 106 'Renfrewshire', 'Isle of Gigha', 'Isle of Islay', 'Isle of Jura', 107 'Isle of Colonsay', 'Isle of Mull', 'Isle of Iona', 'Isle of Tiree', 108 'Isle of Coll', 'Isle of Barra', 'Isle of South Uist', 'Isle of North Uist', 109 'Isle of Harris', 'Isle of Scalpay', 'Isle of Harris', 'Isle of Lewis', 110 'Isle of Benbecula', 'Perthshire', 'Angus', 'InvernesS', 'Isle of Eigg', 111 'Isle of Rhum', 'Isle of Canna', 'Shetland') 98 112 ORDER BY d.outward 99 113 EOF
Note: See TracChangeset
for help on using the changeset viewer.