undermaintained Species Galleries

SQL

SELECT page_title
FROM page
JOIN categorylinks ON cl_from = page_id
-- in [[Category:Taxon galleries]]
WHERE cl_to = 'Taxon_galleries'
-- gallery page
AND page_namespace = 0
-- not already a redirect
AND page_is_redirect = 0
-- less than 500 bytes
AND page_len < 500
AND (
  -- either last edited in 2016 or earlier
  (
    SELECT rev_timestamp
    FROM revision
    WHERE rev_id = page_latest
  ) < '20170000000000'
  -- or at most 2 edits after 2016, as well as at least one edit in 2016 or earlier
  OR (
    (
      SELECT COUNT(*)
      FROM revision
      WHERE rev_page = page_id
      AND rev_timestamp >= '20170000000000'
    ) <= 2
    AND EXISTS (
      SELECT * FROM revision
      WHERE rev_page = page_id
      AND rev_timestamp < '20170000000000'
    )
  )
);
-- not included (not possible in Quarry): less than 15 pageviews a month – must be filtered externally
SQL

Checking query status...
