Pending edits by a single user

SQL

SELECT 
  CONCAT("[[",page.page_title,"]]") AS "Cím",
  CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page.page_title,'&oldid=',flaggedpage_pending.fpp_rev_id,'&diff=',page.page_latest,' ellenőriz]') AS 'Ellenőriz'
--  ,  GROUP_CONCAT(actor.actor_name)
FROM page
  INNER JOIN flaggedpage_pending ON flaggedpage_pending.fpp_page_id = page.page_id
  INNER JOIN revision ON revision.rev_page = page.page_id
  INNER JOIN actor ON actor.actor_id  = revision.rev_actor
WHERE rev_id > fpp_rev_id
  AND page.page_namespace = 0
GROUP BY page.page_id
HAVING COUNT(actor_name) = 1 AND GROUP_CONCAT(DISTINCT actor.actor_name) = "Literatúró"
SQL

Checking query status...
