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'
FROM page AS page1
  INNER JOIN flaggedpage_pending ON flaggedpage_pending.fpp_page_id = page1.page_id
WHERE page_namespace = 0
  AND (SELECT GROUP_CONCAT(rev_id) FROM revision 
       INNER JOIN page AS page2 ON revision.rev_page = page2.page_id
       WHERE page1.page_id = page2.page_id AND rev_id > fpp_rev_id
       GROUP BY page2.page_id)
      = 
      (SELECT GROUP_CONCAT(rev_id) FROM revision
       INNER JOIN page AS page2 ON revision.rev_page = page2.page_id
       INNER JOIN change_tag ON change_tag.ct_rev_id = revision.rev_id
       WHERE page1.page_id = page2.page_id AND rev_id > fpp_rev_id AND ct_tag_id = 202 # tag no.
       GROUP BY page2.page_id)
SQL

Checking query status...
