Modules in English Wiktionary in use that were created by Erutuon

SQL

SELECT concat('Module:', page_title) as module, DATE(rev_timestamp) AS creation_date
FROM revision
	INNER JOIN page ON page_id = rev_page
    INNER JOIN actor ON actor_id = rev_actor
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
            JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id
            WHERE lt_namespace = page_namespace
            AND lt_title = page_title
            LIMIT 1)
ORDER BY lower(page_title), page_title;

SQL

Checking query status...