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.