Untitled query #78300

This query is marked as a draft This query has been published by BilledMammal.
SQL

SELECT page_title
FROM page
WHERE page_title IN ("Aldermen Islands (Ruamaahu) Nature Reserve","Alpine Lake / Ata Puai","Aoraki / Mount Cook","Aoraki / Mount Cook National Park","Aoraki / Mount Cook Village","Aotea / Shelly Beach","Ashburton River / Hakatere","Ashley River / Rakahuri","Atiu or Middle Island","Atuanui / Mount Auckland","Aua / King Billy Island","Autere / East End Beach","Avon River / Ōtākaro","Awaroa / Godley Head","Baring Head / Ōrua-pouanui","Blumine Island / Ōruawairua","Browning Pass / Nōti Raureka","Burgess Island (Pokohinu)","Cam River / Ruataniwha","Campbell Island / Motu Ihupuku","Campbell Island / Motu Ihupuku shelf","Canister Cove (Waikokopu)","Cape Kidnappers / Te Kauwae-a-Māui","Cape Reinga / Te Rerenga Wairua","Cave Creek / Kotihotiho","Clutha River / Mata-Au","Codfish Island / Whenua Hou","Colac Bay / Ōraka","Colac Bay / Ōraka","Columbia Bank / Te Nuku-o-Mourea","Cook River / Weheka","Coopers Lagoon / Muriwai","Dart River / Te Awa Whakatipu","Dog Island / Motuwhangaikirehe Island","Double Island (Moturehu) Nature Reserve","Doubtful Sound / Patea","East Cape / Koromere","Estuary of the Heathcote and Avon Rivers/Ihutai","Eyre Mountains / Taka Ra Haka Conservation Park","Fanal Island (Motukino)","Flower Pot (Onoua)","Fox Glacier / Te Moeka o Tuawe","Franz Josef / Waiau","Franz Josef Glacier / Kā Roimata o Hine Hukatere","Gillespies Point / Kōhaihai","Goat Island / Rakiriri","Goat Island / Rakariri Scenic Reserve","Golden Bay / Mohua","Greenstone River / Hokonui","Greville Harbour / Wharariki","Grey River / Māwheranui","Groper Island / Tatapihi","Haast Pass / Tioripatea","Hamilton Island (Karaka) Scenic Reserve","Hāpūpū / J M Barker Historic Reserve","Harris Saddle / Tarahaka Whakatipu","Haukawakawa / Madsen","Haupapa / Tasman Glacier","Hauraki Gulf / Tīkapa Moana","Hawea (Clio Rocks) Marine Reserve","Hāwea / Bligh Sound","Herekōpare Island / Te Marama","Hikurangi / Goulter Hill","Hikurua / de Surville Canyon","Hikurua / de Surville Cliffs","Hinemoatū / Howard River","Hinenui / Nancy Sound","Hollyford River / Whakatipu Kā Tuka","Horoirangi / Drumduan","Horomamae / Owen Island","Howells Point / Taramea","Inainatū / Pile Bay","Island Hill / Tumuaki","Jackson Bay / Okahu","Jacksons Reef / Patuatini","Kahukura (Gold Arm) Marine Reserve","Kaikiekie / Bradshaw Sound","Kaioruru / Church Bay","Kaitangata / Mansons Peninsula","Kaitira / East Entry Point","Karaka / Hamilton Island","Kārewa / Gannet Island","Kauri Point Birkenhead / Te Mātā-rae-o-Mana","Kawhitu or Stanley Island","Kirikirikatata / Mount Cook Range","Kōhatupapā / Ranfurly Bay","Kōkōwhai Bay / Turners Bay","Korowai / Torlesse Tussocklands Park","Kurow Hill / Te Kohurau","Kutu Parera (Gaer Arm) Marine Reserve","Lake Alabaster / Wāwāhi Waka","Lake Browning / Whakarewa","Lake Ellesmere / Te Waihora","Lake Grassmere / Kapara Te Hau","Lake Ianthe / Matahi","Lake Karoro / Mathews","Lake McKerrow / Whakatipu Waitai","Lake Ōkataina / Te Moana i kataina ā Te Rangitakaroro","Lake Rotoiti / Te Roto kite ā Ihenga i ariki ai Kahu","Lake Rotokākahi (Green Lake) Scenic Reserve","Lake Rotoroa / Hamilton Lake","Lake Rotorua / Te Rotorua nui ā Kahumatamomoe","Leaning Rock / Haehaeata","Little Mangere Island (Tapuaenuku) The Fort","Little Mount Peel / Huatekerekere","Lords River / Tūtaekawetoweto","Lyttelton Harbour / Whakaraupō","Mackenzie Pass / Manahuna","Mahināpua Creek / Tūwharewhare","Mākaro / Ward Island","Mākōtukutuku Stream / Washpool Creek","Manawatāwhi / Great Island","Manawatāwhi / Three Kings Islands","Maniaiti / Benneydale","Maniniaro / Angelus Peak","Matapara / Pickersgill Island","Matira / Castle Rock","Matiu / Somes Island","Matukutūreia / McLaughlins Mountain","Maungakiekie / One Tree Hill","Maungakura / Red Hill","Maungarei / Mount Wellington","Maungaroa / Blagdon Hill","Maungawhau / Mount Eden","Meretoto / Ship Cove","Milford Sound / Piopiotahi","Moana Uta (Wet Jacket Arm) Marine Reserve","Moana-whenua-pōuri / Edwardson Sound","Moekawa / South West Island","Moeraki Boulders / Kaihinaki","Moeraki Boulders / Kaihinaki Scenic Reserve","Moeraki River / Blue River","Mokiiti / Little Moggy Island","Mokinui / Big Moggy Island","Motuareronui / Adele Island","Motuihe Island / Te Motu-a-Ihengotuihe","Motukauatiiti / Corsair Bay","Motukauatirahi / Cass Bay","Motukōkako Island / Piercy Island","Motumānawa / Pollen Island","Motunau / Plate Island","Motunui / Edwards Island","Moturoa / Rabbit Island","Motutere / Castle Rock","Mount Alfred / Ari","Mount Anglem / Hananui","Mount Aspiring / Tititea","Mount Charles / Poatiri","Mount Diffenbach (Hemokawa)","Mount Earnslaw / Pikirakatahi","Mount Grey / Maukatere","Mount Harman / Kaniere","Mount Harper / Mahaanui","Mount Hauruia / Bald Rock","Mount Herbert / Te Ahu Pātiki","Mount MacKenzie / Pakihiwitahi","Mount Nimrod / Kaumira","Mount Upright / Te Taumata o Uekanuku","Mount Watkin / Hikaroroa","Moutere Hauriri / Bounty Islands Marine Reserve","Moutere Ihupuku / Campbell Island Marine Reserve","Moutere Mahue / Antipodes Island Marine Reserve","Muhuaka / Capstan Rock","Musick Point / Te Naupata","Mutukaroa / Hamlin Hill","New River / Kaimata","Ngā Atua Tātā / Kerr Point","Ngā Kiore / Jag Rocks","Ngā Motu / Sugar Loaf Islands","Ngataea / Hooper Point","Nine Mile Creek / Kotorepi","North Branch Ashburton River / Hakatere","North-East Reef (Terangi-taumaewa)","Ōhau / West Island","Ōhinerau / Mount Hobson","Ōhuiarangi / Pigeon Mountain","Ōkāritoiti / Lake Windermere","Old Man Range / Kopuwai","Omarupapako / Round Bush Scenic Reserve","Ōmawete / Coopers Knob","Ōparapara / Samson Bay","Ōraumoa / Fighting Bay","Oromaki / North East Island","Ōrongomai / Cass Peak","Ōtāhuhu / Mount Richmond","Ōtaipango / Henderson Bay","Ōtamahua / Quail Island","Ōtānerua / Hatfields Beach","Ōtokitoki / Gollans Bay","Otututu / Rough River","Paengarēhia / Twilight Beach","Paepae-o-Tū / Bream Tail","Pāhātea / Durden Hill","Pana / Blind Jims Creek","Papawhero / Mount Moturoa","Pariroa / Castle Mount","Pariwhero / Red Rocks","Pātakanui Stream / Grannys Creek","Paterson Inlet / Whaka a Te Wera","Pāuakaiwawe / McLarens Bay","Pelorus Sound / Te Hoiere","Pig Island / Mātau","Pigeon Island / Wāwāhi Waka","Pikikirunga / Caanan Downs","Pikimai / Church Hill","Piopiotahi (Milford Sound) Marine Reserve","Pīreka / Low Neck Bay","Pitt Island (Rangiauria)")
AND page_is_redirect = 0
AND page_namespace = 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
