bnwscontest test data

SQL

use bnwikisource_p;
SELECT revision.rev_user_text, COUNT(revision.rev_user_text) 
FROM revision 
INNER JOIN page ON page.page_id = revision.rev_page
WHERE page.page_title 
LIKE ('বুদ্ধের_জীবন_ও_বাণী.djvu%')
AND page.page_namespace=104 
GROUP BY revision.rev_user_text;


USE bnwikisource_p;
SELECT page_title,rev_comment,rev_id,rev_page,rev_user_text,rev_timestamp
FROM revision JOIN page ON page_id = rev_page
WHERE
  page_namespace=104 AND
  page_title RLIKE '^বুদ্ধের_জীবন_ও_বাণী.djvu/' AND  
  rev_comment RLIKE '^/\\\* '
ORDER BY rev_timestamp DESC
LIMIT 5000;



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 = 102 /* N.B. INDEX namespace! */
        AND (edt.rev_timestamp > '20170201000000' /* Revision/edit */
        AND edt.rev_timestamp < DATE_FORMAT(NOW(), 'YYmmddHHiiss'))
GROUP BY ndx.page_title,edt.rev_user_text;
SQL

Checking query status...
