USE tawikisource_p;

SELECT

    CONCAT("# [[Special:Contributions/", actor_name, "]]") AS rev_user_text,

    GROUP_CONCAT(CONCAT("[[", page_namespace, ":", page_title, "]]") SEPARATOR ", ") AS edited_pages

FROM revision

JOIN actor ON rev_actor = actor_id

JOIN page ON rev_page = page_id

WHERE actor_user IS NOT NULL

AND page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_7.pdf/%"

GROUP BY actor_id

ORDER BY COUNT(actor_id) DESC

LIMIT 100;