Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
BilledMammal
.
Toggle Highlighting
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
.
Checking query status...