{{Semi-retired}} users w/o edits after 2018

This query is marked as a draft This query has been published by Cryptic.

Users whose talk page transcludes {{Semi-retired}} (or its redirect {{semiretired}}) who have no (non-deleted) edits after 2018.

For [[WP:VPT#User search by last activity]] circa 10 February 2020.

SQL

SELECT DISTINCT CONCAT('[[User talk:', page_title, ']]') AS utpage
FROM templatelinks
  JOIN page ON page_id = tl_from
WHERE tl_namespace = 10
  AND tl_title IN ('Semi-retired', 'Semiretired')
  AND tl_from_namespace = 3
  AND NOT EXISTS (SELECT 1 FROM revision_userindex
                    JOIN actor_revision ON actor_id = rev_actor
                  WHERE rev_timestamp > '2018'
                    AND actor_name = REGEXP_REPLACE(REPLACE(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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...