ws ta total contributors for EnSarithiram

Fork of ws ta total contributors for muligai agarathi by Info-farmer

This query is marked as a draft This query has been published by Sridharrv2000.

SQL

Use tawikisource_p;
SET @w:=0;
   select Concat("[[user:",actor_name,"|",actor_name, "]](", edits,")") as "இந்நூலின் மெய்ப்புப்பணியில் ஈடுபட்டோர்:<br/>" from (SELECT  actor_name, count(*) as edits FROM revision  join actor ON rev_actor = actor_id#total number of users edited in a book
       WHERE rev_page IN (select page_id from page where page_title like "என்_சரித்திரம்,_உவேசா,_1990.pdf%")
       group by actor_name) as tt
    order by edits desc
       LIMIT 100;

SQL

Checking query status...