Untitled query #77631

SQL

SELECT
  page.page_title 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
  page
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
WHERE
  page.page_title IN ('Локатор (Apple)')
GROUP BY
  page.page_title
ORDER BY
  page.page_title;
SQL

Checking query status...
