Untitled query #78300

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

SELECT page_title, rev_timestamp
FROM page
JOIN revision ON rev_page = page_id
JOIN comment ON rev_comment_id = comment_id
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
AND comment_text LIKE "%moved page%"
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...
