WStaதமிழ்_நாடக_வரலாறும்_சங்கரதாச_சுவாமிகளும்

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 "தமிழ்_நாடக_வரலாறும்_சங்கரதாச_சுவாமிகளும்.pdf%")
       group by actor_name) as tt
    order by edits desc
       LIMIT 100;

SQL

Checking query status...