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
MisterSynergy
.
Toggle Highlighting
SQL
USE wikidatawiki_p; #SELECT # SUBSTR(revision.rev_timestamp, 1, 8) AS bucket, # COUNT(revision.rev_id) AS cnt #FROM # revision JOIN actor_revision ON actor_revision.actor_id=revision.rev_actor #WHERE # revision.rev_page IN (SELECT page_id FROM page WHERE page_namespace=120) # AND actor_revision.actor_user IS NULL #GROUP BY # bucket; #SELECT # revision.rev_page, # COUNT(revision.rev_id) AS cnt #FROM # revision JOIN actor_revision ON actor_revision.actor_id=revision.rev_actor #WHERE # revision.rev_page IN (SELECT page_id FROM page WHERE page_namespace=120) # AND actor_revision.actor_user IS NULL #GROUP BY # revision.rev_page; #SELECT page_id, page_title FROM page WHERE page_namespace=120; SELECT * FROM change_tag_def; #SELECT # COUNT(*) AS cnt #FROM # revision r_vd # JOIN actor_revision ON actor_revision.actor_id=r_vd.rev_actor # JOIN revision r_undo ON r_vd.rev_id=r_undo.rev_parent_id # JOIN change_tag ON r_undo.rev_id=change_tag.ct_rev_id # JOIN change_tag_def ON change_tag.ct_tag_id=change_tag_def.ctd_id #WHERE # actor_revision.actor_user IS NULL # AND change_tag_def
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...