Untitled query #67866

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

USE dewiki_p;
SELECT distinct p.page_title, c.pl_title FROM page p
join pagelinks c on p.page_id = c.pl_from
where c.pl_namespace = 14
and c.cl_to in ('Belege fehlen','Kategorie:Wikipedia:Überarbeiten','Wikipedia:Defekte Weblinks/Bot')
and p.page_title in ('Abatai','1990er','Point-and-Click-Adventure','Old People','Raven’s Hollow','Return to Monkey Island','No for an Answer','Ecuadorianische Küche','Gateway (Computerspiel)','Rikk Agnew','Somnio','Jodie Faster','Soonago','Eastern Main Road','Kapitän Platte','International Soca Monarch','Pain Teens','Ras Shorty I','Post Mortem (Computerspiel)','From the Gates of Aksum','Order of the Republic of Trinidad and Tobago','Carnival Road March','Solasta: Crown of the Magister','Sin Secretos con Doris','The Cult of the Will','Costa-ricanische Küche','Crapoulet Records','Warrior Kids','Cellebrite','Caribbean’s Next Top Model','Sarapiquí','Jamaat al Muslimeen','Daniel Schneiker','J.U.L.I.A.: Among the Stars','Gamma Force in Pit of a Thousand Screams','Deepfake-Pornographie','Drachen von Laas','Coktel Vision','Pisco Punch','Karl Kritz','Marianne River','Sauce chien','Pokey Mo','Bazodee','Westafrikanische Küche','Choose Your Own Adventure','Moruga','Beyond a Steel Sky','Thaumistry: In Charm’s Way','Agression','Wahl zum Repräsentantenhaus in Trinidad und Tobago 2020','All Fours','Mike Verdu','Saheena','Gender Reveal Party','Louis Lee Sing','Hamburger Hill (Band)','June’s Journey','Herald (Computerspiel)','Chilenische Küche','12:08 Jenseits von Bukarest','Shannara','Finger weg!','Dalgona Coffee','Supreme League of Patriots','Green Swizzle','House of Angostura','Brian Moriarty','Angelo Bissessarsingh','Yaybahar','Santa Cruz (Trinidad und Tobago)','Postal 4: No Regerts','Frederick Street','Really Red','Syberia (Computerspiel)','Karborn','Dark Encounter','Freaks – Sie sehen aus wie wir','Ready or Not – Auf die Plätze, fertig, tot','Choka','Royal Castle','Simon the Sorcerer 3D','Big Boys','Jonathan (Computerspiel)','Cosmo Park','Chiswick Records','Die Stadt der Löwen','Adi Bakel','Rio Claro (Trinidad und Tobago)','Jalebi','Firni','Mushawa','Articles of Faith','Otra Salida','Crime Time','Chilaquiles','Dreamfall: The Longest Journey','Villa Marittima','The Fix','Rafael Delgado (Gouverneur)','Her Majesty’s SPIFFING','My Time At Portia','British West Indies Regiment','Mekanik Destrüktiw Komandöh','Caroni Plain','Eddoes Talkari','Jet Black (Musiker)','Mandy (2018)','Enchanted Scepters','Isa Müller','Agent 86','The Happytime Murders','Anna und die Apokalypse','Broken Teeth','Heavy Trip','Border (2018)','Valley of Shadows','Elizabeth Harvest','The Gospel According to the Meninblack','Shine Rice','Face Noir','The Endless','Tendencia','Get the Shot','Calypso Rose','Maryland Deathfest','Oropuche River','Chepang','Cromwell House','Carenage','Trincity','Cards Against Humanity','Kolumbianische Küche','Citizens Arrest','Through the Woods','Breakers','Ralph Woodford','Panamaische Küche','Carrera Island','Blotnik Brothers','Trash Talk','Shin Ramyun','Lords of Time','Tom Kha Kai','Red House (Port of Spain)','Sommerrolle','Noise the Show','Even Worse','Vitality Air','Hotel Monterey Osaka','Memento Mori 2','Arthur Cipriani','Paula Mae Weekes','Melbourne House','Offenders','Brian Lara Cricket Academy','1893: A World’s Fair Mystery','Ellerslie Park','Overclocked','Chain of Strength','Emperor Valley Zoo','Edward Beetham','Benjamin Chee Chee','Liste von Textadventures','Desert Hot Springs Motel','76% Uncertain','Spider Crew','Crash Test Aglaé','Solitaire (Film)','Parang (Musikrichtung)','Lost Horizon 2','Breadfruit Oil-Down','Die Säulen der Erde (Computerspiel)','Tass Times in Tonetown','Questions','Central F.C.','Trinidad Guardian','Miozän (Band)','Spellcasting 301','I Am Revenge','Churchill Roosevelt Highway','Lungfish','Doh Say Dat','Hector William Munro','The Darkside','Einsamkeit und Sex und Mitleid','False Prophets','Superblue','Paradigm','Syberia 3','Cathedral Oceans II','Marginal Man (Band)','El Nido Airport','Road to India','Caigual','Green Days by the River','Luisa Calderon','ABC No Rio','Lane Mastodon vs. the Blubbermen','Sprangalang','Scrunter','Under the Shadow','Ooze','Marco-Polo-Tower','Urban Waste','Die feine Gesellschaft','Hexuma','Barataria','Zork Nemesis','The Meatmen','Güiria','Couva','Salma (1985)','Normality','Antonio Barreto','Seduction Cinema','Erin Brown','Vitamin X','Tacarigua','The Raven: Vermächtnis eines Meisterdiebs','Heart Attack (Band)','Gérard Besson (Historiker)','Lighthouse Reef','Cronstadt Island','Black Stalin','Antidote (Hardcore-Band)','Mercenaire','Raving Iran','Mosaic Publishing','Holy Trinity Cathedral (Port of Spain)','My Big Night','Die Arche (Roman)','United Mutation','Adrian Cola Rienzi','Arouca','Arouca (Trinidad und Tobago)','The Book of Unwritten Tales 2','Ashdautas','Kona (Computerspiel)','Bacolet','Tablet (Süßware)','Jerry’s Kids','Cocorite','Peter Minshall','Jean-Jacques Burnel','Fran Bow','Queen’s Park Savannah','Hatebeak','The Raven (Album)','Stasis (Computerspiel)','Pig foot souse','Trinidad Express','Solomon Hochoy','Caroni Swamp','UBH','Uriah Butler Highway','Spazz','Brimstone (Computerspiel)','Petrotrin','Lancelot (Computerspiel)','King Art','The Fiend','William Fullarton','Destra Garcia','Ceville','The Mob (Hardcore-Band)','El Tucuche','Champs Fleurs','Ortoire River','Memento Mori (Computerspiel)','Void (Band)','East-West Corridor','San Juan (Trinidad und Tobago)','Michel-Jean Cazabon','El Clan','Alternative Software','Chuck Norris und der Kommunismus','The Undead','15 Days','Martin Ganteföhr','Juan Francisco Machado','Seven Minutes of Nausea','Spellcasting 201','White Flag (Band)','Untouchables (Band)','Subject 13','Little Gasparee','Laventille','Quarterstaff','New York Thrash','Cathedral of the Immaculate Conception (Port of Spain)','Hellowoon','A7 (Club)','A Perfect Day (2015)','Fyzabad','Die Kathedrale (Computerspiel)','Valsayn','Uriah Butler','Keith Rowley','Keith Rowley (Politiker)','Wahl zum Repräsentantenhaus in Trinidad und Tobago 2015','Oöphoi','The Pleasures of Electricity','Return to Zork','Deathgasm','Andrarakh · (Deleted)','Homesick (Computerspiel)','D.I.','Belmont (Port of Spain)','Movimiento por la Autodeterminación e Independencia del Archipiélago Canario','Siparia (Trinidad und Tobago)','Lord of the G-Strings','Sancoche','Long Caye','Men & Chicken','Sir Solomon Hochoy Highway','Frauenlager der Ninja','Siparia (Region)','Black and White (Album)','Django Nudo und die lüsternen Mädchen von Porno Hill','St. Joseph (Trinidad und Tobago)','Johnny Moped','Adrenalin O.D.','Caroni River','House of Tales','Essex (Computerspiel)','Silvertop','Scapeghost','Martín de Salaverría','Spellcasting 101','Gaspar Grande','Morvant','Arthur: The Quest for Excalibur','Svffer','Anthony de Verteuil','Banutzer:Grueslayer/Vorlagen/Band · (Deleted)','Magnificent Seven (Port of Spain)','Caroni (1975) Limited','The Stimulators (Punkband)','Conejo en Salmorejo','Triple X Records','Cathedral Oceans','Zork: Der Großinquisitor','Moho Caye','Penal-Debe','No More Heroes (Album)','Pepperpot','Fuck Art, Let’s Dance!','Dragonsphere','Cranberry Production','Michael Anthony (Autor)','The Abused','Rock & Wrestling','Myth (Computerspiel)','Mindwheel','Knight Orc','Carling House','Eric the Unready','Journey (Computerspiel, 1989)','Machel Montano','Life Is Strange','The Journey Down','Chaguanas','Bocas Islands','Raymond Barbieri','Lost & Found Records','Curepe','Fort George (Trinidad)','José María Chacón','Golf von Paria','Meridian Brothers','Shifting City','Pastelles','The 90’s Suck & So Do You','Geera Pork','Princes Town (Region)','Rattus Norvegicus (Album)','Cassareep','Fish!','Lure of the Temptress','Amnesia (Computerspiel, 1986)','Ingrid’s Back','Laughing Bird Caye','Shogun (Computerspiel)','Kerwin Du Bois','Pearlman Mountain Cabin','Trinidadische Küche','St. Augustine (Trinidad und Tobago)','Lee Ving','Monos (Insel)','Fort San Andres','In Mysterious Ways','Wizarbox','Pelau','STP Not LSD','Mayaro-Rio Claro','Rainbird Software','Corruption (Computerspiel)','Mirrorsoft','Auf Wiedersehen Monty','Gnome Ranger','Kettel (Musiker)','St. George’s Caye','Zork Zero','Arango House','Tunapuna','Huevos','Papo & Yo','The Golden Section','Yesterday Started Tomorrow','Kuchela','Nikopol: Die Rückkehr des Unsterblichen','Couva-Tabaquite-Talparo','Jinxter','Monty on the Run','Dynamite Dan 2','Half Moon Caye','Ensemble Micrologus','Antiseen','Chacachacare','Bunji Garlin','John Foxx/Diskografie','Carib Brewery','Amerzone','Dynamite Dan','Necros','Goff’s Caye','Chaguaramas','Chaguaramas (Trinidad und Tobago)','The Garden (Album)','Reprobates','Sangre Grande (Region)','Anti-Everything','Cayo Espanto','Beyond Zork','Diego Martin (Region)','Caye Chapel','Confronto','San Juan-Laventille','Blackadore Caye','Slap A Ham Records','Plundered Hearts','Paradise (Computerspiel)','Back from Samoa','Alter Ego (Computerspiel 2010)','Stationfall','Tunapuna-Piarco','Hollywood Hijinx','Northern Range','Sheats-Goldstein Residence','Fay-Ann Lyons','Mauby','White Birds Productions','Cutthroats','Aloo Pie','Seastalker','Future Games','Punta Rock','Buljol','Infidel','We Bite Records','Suspended','Kanka (Musiker)','Pholourie','Sinking Island','Wishbringer','Spellbreaker','Sorcerer (Computerspiel)','Doubles','Enchanter','Tony James','Bake and Shark','Dead Reefs','Callaloo','Asa Wright Nature Centre','Norte Cartel','Inside My Brain','Roti (Imbiss)','The Cat Lady','Yacøpsæ','Blanchisseuse','Peter Moore (Autor)','Gary Buslik')
ORDER BY p.page_title desc;
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...
