-- Define your list of article names here

WITH articles_to_check AS (

  SELECT 'Інцели' AS article_name

)

​

-- Main query

SELECT

  atc.article_name AS page_name,

  MAX(revision.rev_id) AS current_rev_id,

  MAX(revision.rev_timestamp) AS current_rev_timestamp,

  CASE

    WHEN MAX(revision.rev_id) = MAX(recentchanges.rc_this_oldid) AND MAX(recentchanges.rc_patrolled) = 1 THEN 'patrolled'

    WHEN MAX(rev_patrolled.rc_patrolled) = 1 THEN 'new_changes'

    ELSE 'unpatrolled'

  END AS status

FROM

  articles_to_check atc

LEFT JOIN

  page ON atc.article_name = page.page_title

LEFT JOIN

  revision ON page.page_id = revision.rev_page

LEFT JOIN

  recentchanges ON revision.rev_id = recentchanges.rc_this_oldid

                  AND recentchanges.rc_namespace = page.page_namespace

LEFT JOIN

  recentchanges rev_patrolled ON revision.rev_id = rev_patrolled.rc_this_oldid

                  AND rev_patrolled.rc_namespace = page.page_namespace

GROUP BY

  atc.article_name

ORDER BY

  atc.article_name;

​