Modules in English Wiktionary in use that were created by Erutuon

SQL

USE enwiktionary_p;
SELECT concat('Module:', page_title), DATE(rev_timestamp) AS creation_date
FROM revision_userindex
	INNER JOIN page ON page_id = rev_page
    INNER JOIN revision_actor_temp ON revactor_rev = rev_id
    INNER JOIN actor ON revactor_actor = actor_id
WHERE page_namespace = 828 -- Module namespace
AND page_title NOT LIKE '%/%' -- Root pages only
AND actor_name = 'Erutuon'
AND rev_parent_id = 0
-- Page has at least one transclusion
AND EXISTS (SELECT 1 FROM templatelinks
            WHERE tl_namespace = page_namespace
            AND tl_title = page_title
            LIMIT 1)
ORDER BY page_title;

SQL

Checking query status...