Articles with pending changes all having a given tag

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 AS firstrev ON firstrev.rev_page = page.page_id
  INNER JOIN revision AS rev ON rev.rev_page = page.page_id
  INNER JOIN change_tag ON change_tag.ct_rev_id = rev.rev_id
WHERE rev.rev_id > fpp_rev_id
  AND page.page_namespace = 0
  AND ct_tag_id = 202 # newcomer task add link
GROUP BY page.page_id

SQL

Checking query status...