List of Wikimedia deployed extensions, order by creation date, newest first

SQL

SELECT MIN(rev_timestamp) AS creation_date,
  page_title AS extension_name,
  user_name AS page_creator
FROM page
LEFT JOIN revision_userindex ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
JOIN user ON actor_user = user_id
JOIN templatelinks ON tl_from = page_id
JOIN linktarget ON tl_target_id = lt_id
WHERE page_namespace = 102
  AND page_title NOT LIKE '%/%' -- filter out subpages
  AND page_is_redirect = 0 -- filter out redirects
  AND lt_namespace = 10 -- Template:OnWikimedia
  AND lt_title = 'OnWikimedia' -- Template:OnWikimedia
GROUP BY page_title
ORDER BY MIN(rev_timestamp) DESC

SQL

Checking query status...