(Translated by
https://www.hiragana.jp/
)
Rotlinks mit Parteikürzel als Klammerlemma - Quarry
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
Wurgl
.
Toggle Highlighting
SQL
USE dewiki_p; SELECT STRAIGHT_JOIN fromPage.page_title, pl_title, SUBSTRING_INDEX(pl_title, "(", -1) AS "Partei" FROM pagelinks LEFT JOIN page AS toPage ON toPage.page_namespace = pl_namespace AND toPage.page_title = pl_title, page as fromPage WHERE pl_from_namespace = 0 AND pl_namespace = 0 AND toPage.page_id IS NULL AND (pl_title like "%(SPD%" OR pl_title like "%(CDU%" OR pl_title like "%(CSU%" OR pl_title like "%(FDP%" OR pl_title like "%(Grüne%" OR pl_title like "%(KPD%" OR pl_title like "%(NPD%" OR pl_title like "%(Link%" OR pl_title like "%(REP%" OR pl_title like "%(Republikaner%" OR pl_title like "%(APPD%" OR pl_title like "%(Bauernbund%" OR pl_title like "%(BDL%" OR pl_title like "%(BDP%" OR pl_title like "%(BGB%" OR pl_title like "%(BP%" OR pl_title like "%(BVP%" OR pl_title like "%(CP%" OR pl_title like "%(CPÖ%" OR pl_title like "%(CS%" OR pl_title like "%(CVP%" OR pl_title like "%(DBD%" OR pl_title like "%(DDP%" OR pl_title like "%(DFP%" OR pl_title like "%(DKP%" OR pl_title like "%(DNP%" OR pl_title like "%(DNVP%" OR pl_title like "%(DP%" OR pl_title like "%(DRP%" OR pl_title like "%(DSVP%" OR pl_title like "%(DTVP%" OR pl_title like "%(DVP%" OR pl_title like "%(DVU%" OR pl_title like "%(FBP%" OR pl_title like "%(FDBG%" OR pl_title like "%(FOP%" OR pl_title like "%(Fortschrittspartei%" OR pl_title like "%(FPS%" OR pl_title like "%(FVG%" OR pl_title like "%(FVP%" OR pl_title like "%(FW%" OR pl_title like "%(GB/BHE%" OR pl_title like "%(GDP%" OR pl_title like "%(GPS%" OR pl_title like "%(HBB%" OR pl_title like "%(KP%" OR pl_title like "%(KVP%" OR pl_title like "%(LDP%" OR pl_title like "%(LDPD%" OR pl_title like "%(LDU%" OR pl_title like "%(Liberale_Vereinigung%" OR pl_title like "%(MDA%" OR pl_title like "%(MDB%" OR pl_title like "%(MDBB%" OR pl_title like "%(MDFN%" OR pl_title like "%(MDHDa%" OR pl_title like "%(MDL%" OR pl_title like "%(MDR%" OR pl_title like "%(NDP%" OR pl_title like "%(NDPD%" OR pl_title like "%(NLP%" OR pl_title like "%(NSDAp%" OR pl_title like "%(NSFP%" OR pl_title like "%(ÖDP%" OR pl_title like "%(ÖVP%" OR pl_title like "%(PDS%" OR pl_title like "%(Radikale_Partei%" OR pl_title like "%(SDAP%" OR pl_title like "%(SDP%" OR pl_title like "%(SED%" OR pl_title like "%(SP%" OR pl_title like "%(SPÖ%" OR pl_title like "%(SPS%" OR pl_title like "%(USPD%" OR pl_title like "%(VRP%" OR pl_title like "%(VU%" OR pl_title like "%(WBWB%" OR pl_title like "%(Zentrum%" OR pl_title like "%(Abgeordneter%" OR pl_title like "%(Bundeskanzler%" OR pl_title like "%(Bundespräsident%" OR pl_title like "%(Bundestagsabgeordneter%" OR pl_title like "%(Bürgermeister%" OR pl_title like "%(Delegierter%" OR pl_title like "%(Gouverneur%" OR pl_title like "%(Justizminister%" OR pl_title like "%(Kongressabgeordneter%" OR pl_title like "%(Kontinentalkongress%" OR pl_title like "%(Landeshauptmann%" OR pl_title like "%(Landrat%" OR pl_title like "%(Landtagsabgeordneter%" OR pl_title like "%(Minister%" OR pl_title like "%(Ministerpräsident%" OR pl_title like "%(Nationalrat%" OR pl_title like "%(Nationalratsabgeordneter%" OR pl_title like "%(Oberbürgermeister%" OR pl_title like "%(Premierminister%" OR pl_title like "%(Senator%" OR pl_title like "%(Staatsminister%" OR pl_title like "%(Vizegouverneur%" OR pl_title like "%(Vizeminister%") AND fromPage.page_id = pl_from
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...
