Untitled query #77631

SQL

-- 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;
SQL

Checking query status...
