Untitled query #31960

SQL

USE tawikisource_p;
select page_id, page_title from page where page_title like "%கடவுள்_வழிபாட்டு_வரலாறு.pdf%";
       SELECT  CONCAT('[[User:',rev_user_text,'|',rev_user_text,']]', ' (', count(*) as edits,')') As User FROM revision #total number of users edited in a book
       WHERE rev_page IN (select page_id from page where page_title like "%கடவுள்_வழிபாட்டு_வரலாறு.pdf%")
       group by rev_user_text 
       order by edits desc
       LIMIT 100;
SQL

Checking query status...
