SQL
AخA
SELECT 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 = 'Mr. Stradivarius' OR actor_name = 'Mr. Stradivarius on tour')
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.