This query is marked as a draft This query has been published by FoBe.

SQL

AخA
 
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)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...