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_title, count(distinct enwiki_p.revision.rev_id) as Revision_Count, 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')) as Percent_of_Revisions from page inner join revision on page.page_id = revision.rev_page where page_title in ('Salt', 'Sugar') group by 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')),2)*100 as Perc_Total_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, from page left outer join revision on page.page_id = revision.rev_page where page_title in ('Salt','Sugar') group by page_id, page_namespace, 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...