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 items by author on plwiki
by
The Polish
This query is marked as a draft
This query has been published
by
Edgars2007
.
Toggle Highlighting
SQL
USE lvwiki_p; SELECT CONCAT('[[User:',rev_user_text,']]'), COUNT(*) AS counting FROM page LEFT JOIN langlinks ON ll_from = page_id LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id LEFT JOIN revision ON rev_page = page_id WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_parent_id = 0 AND ll_title IS NULL AND pp_value IS NULL AND NOT EXISTS (SELECT * FROM plwiki_p.page_props AS disambig1 WHERE disambig1.pp_propname LIKE 'disambiguation' AND disambig1.pp_page = plwiki_p.page.page_id) GROUP BY rev_user_text ORDER BY counting 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
.
Checking query status...