Untitled query #86223

SQL

SELECT page_title AS 'Module',
       DATE_FORMAT(MIN(rev_timestamp), '%Y-%m-%d') AS 'First edit',
       DATE_FORMAT(MAX(rev_timestamp), '%Y-%m-%d') AS 'Latest edit',
       COUNT(DISTINCT rev_actor) AS 'Unique authors',
       COUNT(rev_id) AS 'Revisions',
       (
         SELECT actor_name
         FROM revision
         LEFT JOIN actor ON actor.actor_id = revision.rev_actor
         WHERE revision.rev_page = unused_modules.page_id
         ORDER BY revision.rev_timestamp
         LIMIT 1
       ) AS 'Creator'
FROM
(
  SELECT page_id,
         page_title
  FROM page AS module
  WHERE NOT EXISTS
    (
      SELECT 1
      FROM templatelinks
      JOIN linktarget ON lt_id = tl_target_id
      JOIN page AS transcluder ON transcluder.page_id = tl_from
      WHERE lt_namespace = module.page_namespace
        AND lt_title = module.page_title
        AND tl_from != module.page_id
        AND NOT (transcluder.page_namespace = 11 AND transcluder.page_title = module.page_title)
        AND NOT (transcluder.page_namespace = 10
                 AND LEFT(transcluder.page_title, LENGTH(module.page_title) + 1) = CONCAT(module.page_title, '/'))
        AND NOT (transcluder.page_namespace = 2
                 AND transcluder.page_title = 'I_am_RedoStone/sandbox')
      LIMIT 1
    )
    AND page_namespace = 828  -- Namespace for modules
    AND page_is_redirect = 0
    AND page_title NOT LIKE 'Module:Sandbox/%'  -- Exclude sandbox modules
    AND page_title NOT LIKE '%/sandbox%'  -- Exclude any pages containing '/sandbox'
) AS unused_modules
STRAIGHT_JOIN revision ON rev_page = unused_modules.page_id
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
GROUP BY page_title;
SQL

Checking query status...
