Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Monumental-glam: count of unique pages of items in Sweden edited
by
Alicia Fagerving (WMSE)
This query is marked as a draft
This query has been published
by
André Costa (WMSE)
.
Also counts the total number of actors
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT COUNT( DISTINCT(r.rev_page) ) as num_pages COUNT( DISTINCT(r.user) ) as num_users FROM wikidatawiki_p.revision r JOIN change_tag ON r.rev_id=change_tag.ct_rev_id JOIN wikidatawiki_p.pagelinks pagelinks ON r.rev_page=pagelinks.pl_from WHERE change_tag.ct_tag_id=604 -- OAuth CID: 1311 AND pagelinks.pl_title="Q34" # Sweden
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...