Articles with pending changes all having a given tag

SQL

SELECT 
  CONCAT("[[",page1.page_title,"]]") AS "Cím",
  CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&oldid=',flaggedpage_pending.fpp_rev_id,'&diff=',page1.page_latest,' ellenőriz]') AS 'Ellenőriz'
--  ,  GROUP_CONCAT(actor.actor_name)
FROM page AS page1
  INNER JOIN flaggedpage_pending ON flaggedpage_pending.fpp_page_id = page1.page_id
  INNER JOIN revision ON revision.rev_page = page1.page_id
#  INNER JOIN change_tag ON change_tag.ct_rev_id = revision.rev_id
WHERE #page1.page_id = 19065 AND
  page_id = 18378 AND
  rev_id > fpp_rev_id
  AND page1.page_namespace = 0
  AND rev_id = ALL 
  (SELECT revision2.rev_id FROM revision AS revision2 
   INNER JOIN page AS page2 ON revision2.rev_page = page2.page_id
   INNER JOIN change_tag ON change_tag.ct_rev_id = revision2.rev_id 
   WHERE page2.page_id = page1.page_id AND revision2.rev_id>fpp_rev_id AND ct_tag_id = 202)
#  AND ct_tag_id = 202 # newcomer task add link
#GROUP BY page.page_id
SQL

Checking query status...
