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
AuFCL
.
enWS PoM March 2015 edit-in-namespace detail summary
Toggle Highlighting
SQL
SELECT edt.rev_user_text as 'Editor', ndx.page_title as 'Work', edp.page_namespace, /*count(*/edp.page_namespace = 104/*) as 'Page-space: edits'*/, /*count(*/edp.page_namespace = 106/*) as 'Index-space: edits'*/, /*count(*/edp.page_namespace = 0/*) as 'Main-space: edits', COUNT(edp.page_id)-count(edp.page_namespace in (0,104,106)) AS 'Other edits'*/ FROM enwikisource_p.page ndx INNER JOIN enwikisource_p.pagelinks lnk ON ndx.page_id = lnk.pl_from INNER JOIN enwikisource_p.page edp ON edp.page_title = lnk.pl_title INNER JOIN enwikisource_p.revision edt ON edp.page_id = edt.rev_page WHERE ndx.page_title IN ('Great_Neapolitan_Earthquake_of_1857.djvu') AND ndx.page_namespace = 106 /* N.B. INDEX namespace! */ AND (edt.rev_timestamp > '20150201000000' /* Revision/edit */ AND edt.rev_timestamp < DATE_FORMAT(NOW(), 'YYmmddHHiiss')) /*GROUP BY ndx.page_title,edp.page_namespace,edt.rev_user_text*/ limit 100;
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...