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