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;
SQL

Checking query status...
