Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Articles not connected to Wikidata but similar to enwiki articles on plwiki
by
The Polish
This query is marked as a draft
This query has been published
by
Estopedist1
.
Toggle Highlighting
SQL
SELECT CONCAT('[[',plwiki_p.page.page_title,']]') AS pl, CONCAT('[[',enwiki_p.page.page_title,']]') AS en FROM enwiki_p.page JOIN plwiki_p.page ON enwiki_p.page.page_title = plwiki_p.page.page_title LEFT JOIN plwiki_p.langlinks ON ll_from = plwiki_p.page.page_id LEFT JOIN (SELECT * FROM plwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = plwiki_p.page.page_id LEFT JOIN plwiki_p.templatelinks ON tl_from = plwiki_p.page.page_id WHERE plwiki_p.page.page_namespace = 0 AND plwiki_p.page.page_is_redirect = 0 AND enwiki_p.page.page_namespace = 0 AND enwiki_p.page.page_is_redirect = 0 AND ll_title IS NULL AND pp_value IS NULL AND NOT EXISTS (SELECT * FROM plwiki_p.templatelinks AS tl1 WHERE plwiki_p.page.page_id = tl1.tl_from AND plwiki_p.page.page_namespace = tl1.tl_from_namespace AND tl_namespace = 10 AND tl_title LIKE 'Ujednoznacznienie') AND NOT EXISTS (SELECT * FROM enwiki_p.templatelinks AS tl1 WHERE enwiki_p.page.page_id = tl1.tl_from AND enwiki_p.page.page_namespace = tl1.tl_from_namespace AND tl_namespace = 10 AND tl_title LIKE 'Disambiguation') GROUP BY enwiki_p.page.page_title, plwiki_p.page.page_title;
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...