Untitled query #77631

SQL

WITH articles_to_check AS (
  SELECT
    'Локатор (Apple)' AS article_name
  UNION
  SELECT
    'Інцели' AS article_name

)

SELECT
  atc.article_name AS page_name,
  revision.rev_id,
  revision.rev_timestamp,
  CASE
    WHEN recentchanges.rc_patrolled = 1 THEN 'patrolled'
    WHEN recentchanges.rc_id IS NOT NULL 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
WHERE
  revision.rev_id = (SELECT MAX(rev_id) FROM revision WHERE rev_page = page.page_id)
ORDER BY
  atc.article_name;
SQL

Checking query status...
