Unreviewed changes by trusted users

SQL

# USE huwiki_p; -- deprecated
SELECT CONCAT('[[',page1.page_title,']]') AS 'Cím', 
	CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&action=history történet]') AS 'Történet', 
    CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&oldid=',flaggedpage_pending1.fpp_rev_id,'&diff=',page1.page_latest,' ellenőriz]') AS 'Ellenőriz', 
    GROUP_CONCAT(DISTINCT actor1.actor_name SEPARATOR ', ') AS 'Szerkesztők',
    CONCAT(FLOOR(lastrevision.rev_timestamp/10000000000),'-',
           FLOOR(lastrevision.rev_timestamp/100000000)-FLOOR(lastrevision.rev_timestamp/10000000000)*100,'-',
           FLOOR(lastrevision.rev_timestamp/1000000)-FLOOR(lastrevision.rev_timestamp/100000000)*100,' ',
           FLOOR(lastrevision.rev_timestamp/10000)-FLOOR(lastrevision.rev_timestamp/1000000)*100) AS 'Utolsó módosítás'
    #, flaggedpage_pending1.fpp_pending_since #, GROUP_CONCAT(user_groups.ug_group) AS 'jogok'
FROM page as page1
INNER JOIN revision AS lastrevision ON page1.page_latest = lastrevision.rev_id -- used for outputting timestamp of last edit, not used in rest of query
INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page
INNER JOIN flaggedpage_pending AS flaggedpage_pending1 ON page1.page_id = flaggedpage_pending1.fpp_page_id
INNER JOIN actor AS actor1 ON revision1.rev_actor = actor1.actor_id
INNER JOIN user AS user1 ON actor1.actor_user = user1.user_id
LEFT OUTER JOIN user_groups AS user_groups1 ON ug_user = actor_user
WHERE page1.page_namespace = 0
    AND revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
    AND user_groups1.ug_group IN ('editor','trusted','sysop','bot')
    AND page1.page_id NOT IN ( # exclude edits by anons
    	SELECT page2.page_id
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
     	INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
      	WHERE page1.page_id = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
      		AND actor2.actor_user IS NULL
    	)
     AND page1.page_id NOT IN ( # exclude edits by non-trusted users
        SELECT page2.page_id
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
     	INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
        INNER JOIN user AS user2 ON actor2.actor_user = user2.user_id
      	WHERE page1.page_id = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
            AND NOT EXISTS (SELECT user_groups2.ug_user FROM user_groups AS user_groups2 WHERE user_groups2.ug_user = user2.user_id AND user_groups2.ug_group IN ('editor','trusted','sysop','bot'))
    	)
GROUP BY page1.page_title
#ORDER BY page1.page_title ASC;
ORDER BY revision1.rev_timestamp DESC;
SQL

Checking query status...
