not sync articles because of IP edits: 2025

SQL

SELECT 
    CONCAT('[[', p.page_title, ']]') AS article,
    a.actor_name AS ip_address,
    r.rev_timestamp AS timestamp
FROM page p
JOIN (
    -- Find pages where the latest revision is not flagged
    SELECT p.page_id
    FROM page p
    JOIN revision r ON r.rev_id = p.page_latest
    LEFT JOIN flaggedrevs fr ON fr.fr_rev_id = r.rev_id
    WHERE p.page_namespace = 0
      AND p.page_is_redirect = 0
      AND fr.fr_rev_id IS NULL
) unreviewed_pages ON unreviewed_pages.page_id = p.page_id
JOIN (
    -- For each page, find the latest flagged revision (if any)
    SELECT fr_page_id, MAX(fr_rev_id) AS latest_flagged_rev
    FROM flaggedrevs
    GROUP BY fr_page_id
) latest_fr ON latest_fr.fr_page_id = p.page_id
JOIN revision r ON r.rev_page = p.page_id
JOIN actor a ON r.rev_actor = a.actor_id
WHERE a.actor_user IS NULL
  -- This is the first unreviewed revision after the last flagged one
  AND r.rev_id = (
      SELECT MIN(r2.rev_id)
      FROM revision r2
      WHERE r2.rev_page = p.page_id
      AND r2.rev_id > latest_fr.latest_flagged_rev
  )
  AND r.rev_timestamp >= '20250101000000'
  AND r.rev_timestamp <  '20260101000000'
ORDER BY r.rev_timestamp ASC;
SQL

Checking query status...
