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
XXN
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT MIN(rev_timestamp), rev_id, rev_user_text AS user_name/* COUNT(rev1.rev_id) AS number, SUM(rev1.rev_len) - SUM(rev2.rev_len) AS data_amount, (SUM(rev1.rev_len) - SUM(rev2.rev_len)) / COUNT(rev1.rev_id) AS ratio FROM (SELECT * FROM revision WHERE rev_comment LIKE '%wbmergeitems-from%') AS rev1 */ FROM revision #AS rev2 ON rev2.rev_id = rev1.rev_parent_id #LEFT JOIN user_groups ON rev1.rev_user IS NOT NULL AND ug_user = rev1.rev_user WHERE MIN(left(rev_timestamp,10)) in ("2013010100")
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...