SELECT

  page_title,

  MIN(rev_timestamp),

  MAX(rev_timestamp),

  COUNT(DISTINCT rev_actor),

  COUNT(rev_id)

FROM (

  SELECT

    page_id,

    page_title

  FROM

    page

  LEFT JOIN linktarget ON page_namespace = lt_namespace

    AND page_title = lt_title

  LEFT JOIN templatelinks ON tl_target_id = lt_id AND tl_from <> page_id

  WHERE

    page_namespace = 10

    AND page_is_redirect = 0

    AND tl_target_id IS NULL

    AND page_title NOT LIKE "Adminstats/%"

    AND page_title NOT LIKE "AfC\_%"

    AND page_title NOT LIKE "Cite\_doi/%"

    AND page_title NOT LIKE "Cite\_pmid/%"

    AND page_title NOT LIKE "Did\_you\_know\_nominations/%"

    AND page_title NOT LIKE "Editnotices/%"

    AND page_title NOT LIKE "PBB/%"

    AND page_title NOT LIKE "POTD\_caption/%"

    AND page_title NOT LIKE "POTD\_credit/%"

    AND page_title NOT LIKE "POTD\_protected/%"

    AND page_title NOT LIKE "TemplateStyles\_sandbox/%"

    AND page_title NOT LIKE "TFA\_title/%"

    AND page_title NOT LIKE "User\_%"

    AND page_title NOT LIKE "%/testcases"

    AND page_title NOT LIKE "%/sandbox"

    AND page_title NOT LIKE "%/rater-data.js"

    AND page_title NOT LIKE "%-stub"

    AND page_title NOT IN (

      SELECT

        page_title

      FROM

        page

        JOIN categorylinks ON page_id = cl_from

      WHERE

        cl_to IN (

          'Wikipedia_substituted_templates',

          'Wikipedia_transclusionless_templates',

          'Deprecated_templates_kept_for_historical_reasons',

          'Inactive_project_pages',

          'Parameter_shared_content_templates',

          'Computer_language_user_templates',

          'Language_user_templates',

          'Template_test_cases',

          'Template_sandboxes',

          'Level-zero_userbox_templates',

          'Templates_for_deletion'

        )

        AND page_namespace = 10

    )

  ORDER BY

    page_title ASC

) AS unused_templates

STRAIGHT_JOIN revision ON rev_page = page_id

GROUP BY page_title;