WSta1840-vocabulary of English and Tamil words

Fork of WSen contributors of Tamil proverbs book by Info-farmer

This query is marked as a draft This query has been published by Info-farmer.

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 "1840-vocabulary_of_English_and_Tamil_words_compiled_by_Innocent_Nicholas.pdf%")
       group by actor_name) as tt
    order by edits desc
       LIMIT 100;

SQL

Checking query status...