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
Taavi
.
Toggle Highlighting
SQL
use simplewiki_p; select * from page where page_title in ( "Masada", "Semmering_railway", "Budj_Bim", "Gros_Morne_National_Park", "Kew_Gardens", "Qutub_Minar", "V%C3%A9z%C3%A8re_Valley", "Do%C3%B1ana_National_Park", "Rhodes_(city)", "Butrint", "Himeji_Castle", "Kronborg", "L%27Anse_aux_Meadows", "Vatican_City", "Humayun%27s_Tomb", "Ellora_Caves", "Forth_Rail_Bridge", "Great_Smoky_Mountains_National_Park", "Cornwall_and_West_Devon_Mining_Landscape", "Garajonay_National_Park", "Pont_du_Gard", "Plitvice_Lakes", "Yellowstone_National_Park", "Complex_of_Koguryo_tombs", "Ibiza", "Hadrian%27s_Wall", "Hwaseong_Fortress", "Changdeokgung", "Guanajuato_City", "Tassili_n%27Ajjer", "Ha_Long_Bay", "Tower_of_London", "Zhoukoudian", "M%27banza-Kongo", "Dessau", "Jongmyo", "Jeju_Volcanic_Island_and_Lava_Tubes", "Royal_Tombs_of_the_Joseon_Dynasty", "Jaipur", "Wachau", "Sultan_Ahmed_Mosque", "Delphi,_Greece", "Canadian_Rocky_Mountain_Parks_World_Heritage_Site", "Dinosaur_Provincial_Park", "Giant%27s_Causeway", "Catal_Huyuk", "Amiens_Cathedral", "Somapura_Mahavihara", "Bia%C5%82owie%C5%BCa_Forest", "Kaziranga_National_Park", "A%C3%AFt_Benhaddou", "Al-Hasa", "Verona", "Asmara", "Sucre", "Robben_Island", "Struve_Geodetic_Arc", "Vredefort_crater", "Bhimbetka", "Sundarbans_National_Park", "Chauvet_Cave", "Olympic_National_Park", "Persepolis", "Jeddah", "Ani", "Teruel_Cathedral", "Mount_Athos", "Henderson_Island_(Pitcairn_Islands)", "Acropolis_of_Athens", "Temple_of_Athena_Nike", "Independence_Hall", "Man%C3%BA_National_Park", "Heard_Island_and_McDonald_Islands", "Wood_Buffalo_National_Park", "Nahanni_National_Park_Reserve", "Cave_of_Altamira", "Wuyi_Mountains", "Jurassic_Coast", "Australian_Convict_Sites", "Fraser_Island", "Hawai%CA%BBi_Volcanoes_National_Park", "Blenheim_Palace", "Great_Zimbabwe", "Stonehenge,_Avebury_and_Associated_Sites", "Mir_Castle_Complex", "Virgin_Komi_Forests", "Vilnius_Old_Town", "Al-Aqsa_Mosque", "Bamberg", "Tasmanian_Wilderness", "Wartburg_Castle", "Antonine_Wall", "Kluane_/_Wrangell%E2%80%93St._Elias_/_Glacier_Bay_/_Tatshenshini-Alsek", "Lake_District", "Summer_Palace", "Cologne_Cathedral", "Cop%C3%A1n", "Wulingyuan", "Mahabodhi_Temple", "Messel_pit", "Poblet_Monastery", "Gondwana_Rainforests", "Komodo_National_Park", "Ironbridge_Gorge", "Derwent_Valley_Mills", "Lake_Baikal", "Shark_Bay", "Babylon", "Mohenjo-daro", "Palmyra", "Rohtas_Fort", "Bryggen", "Golden_Mountains_of_Altai", "Petra", "C%C3%B3rdoba,_Andalusia", "Chichen_Itza", "Axum", "Taxila", "Hiroshima_Peace_Memorial_(Genbaku_Dome)", "Aachen_Cathedral", "Shaki,_Azerbaijan", "Pasargadae", "Altes_Museum", "Keoladeo_National_Park", "Pantanal", "St_Kilda", "White_City_of_Tel_Aviv", "Teotihuac%C3%A1n", "Samarra", "Byblos", "Iwami_Ginzan_Silver_Mine", "Fatehpur_Sikri", "Aeolian_Islands", "Chartres_Cathedral", "Mesa_Verde_National_Park", "Chhatrapati_Shivaji_Terminus_railway_station", "Yosemite_National_Park", "Sanchi", "Purnululu_National_Park", "Yakushima", "Head-Smashed-In_Buffalo_Jump", "Ulu%E1%B9%9Fu-Kata_Tju%E1%B9%AFa_National_Park", "Taos_Pueblo", "Tower_of_Hercules", "Great_Barrier_Reef", "Taj_Mahal", "Las_M%C3%A9dulas", "Teide_National_Park", "Statue_of_Liberty", "Djoudj_National_Bird_Sanctuary", "New_Lanark", "Timbuktu", "Beemster", "Willandra_Lakes_Region", "Belfries_of_Belgium_and_France", "Parthenon", "St._Peter%27s_Basilica", "Mount_Etna", "Umayyad_Mosque", "Palenque", "Ajanta_Caves", "Danube_Delta", "Mont-Saint-Michel", "Troy", "Bath,_Somerset", "Papah%C4%81naumoku%C4%81kea_Marine_National_Monument", "Valletta", "Old_Rauma", "Phong_Nha-K%E1%BA%BB_B%C3%A0ng_National_Park", "Castles_and_Town_Walls_of_King_Edward_in_Gwynedd", "Belize_Barrier_Reef", "Grand_Canal_(China)", "Bagan", "Saltaire", "Hoi_An", "Gal%C3%A1pagos_Islands", "Olympia", "Burgess_Shale", "Victoria_Falls", "Royal_Library_of_Turin", "Historic_Monuments_of_Ancient_Kyoto_(Kyoto,_Uji_and_Otsu_Cities)", "Sanqingshan", "Sydney_Opera_House", "Red_Fort", "Macquarie_Island", "Palmeral_of_Elche", "Greater_Blue_Mountains_Area", "Tamgaly", "Inca_road_system", "Kathmandu_Valley", "Gammelstaden", "Chitwan_National_Park", "Quwwat-ul-Islam_mosque", "Wet_Tropics_of_Queensland", "Cradle_of_Humankind", "Historic_Monuments_of_Ancient_Nara", "Shrines_and_Temples_of_Nikk%C5%8D", "Suomenlinna", "Heart_of_Neolithic_Orkney", "%C3%81vila_Cathedral", "Ningaloo_Reef", "Jodrell_Bank_Observatory", "Gammelstad_Church_Town", "Lord_Howe_Island_Group", "Cape_flower_region", "Rock_art_of_the_Iberian_Mediterranean_Basin", "Liverpool_Maritime_Mercantile_City", "Old_Quebec", "Sagarmatha_National_Park", "Monasteries_of_San_Mill%C3%A1n_de_la_Cogolla", "Roman_Walls_of_Lugo", "Historic_Monuments_and_Sites_of_Hiraizumi", "Lugo_Cathedral", "Meteora", "Mistaken_Point_Ecological_Reserve", "Historic_Centres_of_Berat_and_Gjirokastra", "Heritage_of_Mercury._Almad%C3%A9n_and_Idrija", "Frontiers_of_the_Roman_Empire", "Palazzo_Chiablese", "Imperial_City_of_Hue", "Australian_Fossil_Mammal_Sites_(Riversleigh_/_Naracoorte)", "Historic_Monuments_and_Sites_in_Kaesong", "Blaenavon_Industrial_Landscape", "Redwood_National_and_State_Parks", "Alhambra", "Selimiye_Mosque" ) and not exists ( select 1 from templatelinks where tl_from = page_id and tl_title = "WHSite" ) limit 100;
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...