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
Snævar
.
Toggle Highlighting
SQL
select p.page_title, (i.page_len - p.page_len) as diff from enwiki_p.page as p join enwiki_p.categorylinks as c on c.cl_from = p.page_id and c.cl_to = "Articles_needing_translation_from_Icelandic_Wikipedia" join wikidatawiki_p.wb_items_per_site as w on w.ips_site_page = p.page_title and w.ips_site_id = "enwiki" join wikidatawiki_p.wb_items_per_site as b on b.ips_row_id = w.ips_row_id join iswiki_p.page as i on b.ips_site_page = i.page_title limit 200
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...