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
Jayantanth
.
Toggle Highlighting
SQL
SELECT edt.rev_user_text as 'Editor', ndx.page_title as 'Work', sum(edp.page_namespace = 104) as 'Page-space: edits', sum(edp.page_namespace = 102) as 'Index-space: edits', sum(edp.page_namespace = 0) as 'Main-space: edits', COUNT(edp.page_id)-sum(edp.page_namespace in (0,104,102)) AS 'Other edits' FROM bnwikisource_p.page ndx INNER JOIN bnwikisource_p.pagelinks lnk ON ndx.page_id = lnk.pl_from INNER JOIN bnwikisource_p.page edp ON edp.page_title = lnk.pl_title INNER JOIN bnwikisource_p.revision edt ON edp.page_id = edt.rev_page WHERE ndx.page_title IN ('চাঁদের পাহাড়.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,edt.rev_user_text;
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...