Untitled query #77631

SQL

WITH articles_to_check AS (
  SELECT
  unnest(ARRAY['Інцели', 'Локатор (Apple)']) AS article_name
)

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(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
                  AND rev_patrolled.rc_patrolled = 1
GROUP BY
  atc.article_name
ORDER BY
  atc.article_name;
SQL

Checking query status...
