Trust - Quarry

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'
FROM page
INNER JOIN revision AS lastrevision ON page.page_latest = lastrevision.rev_id
INNER JOIN revision AS revision1 ON page.page_id = revision1.rev_page
INNER JOIN flaggedpage_pending ON page.page_id = flaggedpage_pending.fpp_page_id
INNER JOIN actor ON revision1.rev_actor = actor_id
WHERE page_namespace = 0
AND revision1.rev_timestamp >= flaggedpage_pending.fpp_pending_since
AND actor_name = "Stephan1000000"
AND page_title = "A Térség (televíziós sorozat)"
GROUP BY page.page_title
SQL

Checking query status...
