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
Peter Bowman
.
https://pl.wiktionary.org/wiki/Wikipedysta:PBbot/zepsute_linki_do_siostrzanych
Toggle Highlighting
SQL
USE plwiktionary_p; -- Resultset 1: wikisource SELECT page_title AS wikt_page_title, iwl_title AS s_page_title FROM iwlinks INNER JOIN page ON iwl_from = page_id WHERE page_namespace = 0 AND iwl_prefix = "s" AND #iwl_title != "" AND NOT EXISTS ( SELECT NULL FROM plwikisource_p.page AS s_page WHERE s_page.page_title = iwl_title ) ; -- Resultset 2: wikiquote /* SELECT page_title AS wikt_page_title, iwl_title AS q_page_title FROM iwlinks INNER JOIN page ON iwl_from = page_id WHERE page_namespace = 0 AND iwl_prefix = "q" AND #iwl_title != "" AND NOT EXISTS ( SELECT * FROM plwikiquote_p.page AS q_page WHERE q_page.page_title = iwl_title ) LIMIT 10; -- Resultset 3: wikipedia SELECT page_title AS wikt_page_title, iwl_title AS wp_page_title FROM iwlinks INNER JOIN page ON iwl_from = page_id WHERE page_namespace = 0 AND iwl_prefix = "w" AND #iwl_title != "" AND NOT EXISTS ( SELECT NULL FROM plwiki_p.page AS wp_page WHERE wp_page.page_title = iwl_title ) LIMIT 10;*/
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...