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 = rev_actor
        WHERE rev_page = page_id
        ORDER BY 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 transclud
SQL

Checking query status...
