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
TSK80
.
Toggle Highlighting
SQL
USE enwiki_p; select page.*, revision.* /* page_title AS Page_Title, count(distinct enwiki_p.revision.rev_id) as Revision_Count, round((count(distinct enwiki_p.revision.rev_id) /(select count(enwiki_p.revision.rev_id) from enwiki_p.page inner join enwiki_p.revision on page.page_id = revision.rev_page where page_title in ('Salt','Sugar')))*100,2) as Percent_of_Revisions, sum(rev_minor_edit) as Total_Minor_Edits, Round((sum(rev_minor_edit)/count(enwiki_p.revision.rev_id)),2)*100 as Percent_of_Minor_Edits, count(distinct rev_user) as Count_Of_Revisionists, Round((count(distinct enwiki_p.revision.rev_id)/count(distinct rev_user)),2) as Avg_Changes_per_Revisionist, round(avg(rev_len),0) as Avg_Rev_Article_Length */ from revision left outer join page on revision.rev_page = page.page_id where page_title in ('Salt', 'Sugar') group by page_title LIMIT 200000;
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...