Unreviewed changes by trusted users

SQL

USE huwiki_p;
SELECT page1.page_title, GROUP_CONCAT(DISTINCT actor1.actor_name) AS 'user' #, GROUP_CONCAT(user_groups.ug_group) AS 'jogok'
FROM page as page1 #, user_groups
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 revision1.rev_actor = user1.user_id
LEFT OUTER JOIN user_groups AS user_groups1 ON ug_user = actor_user
WHERE TRUE #page1.page_id = 29709
    AND revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
    AND user_groups1.ug_group IN ('editor','trusted','sysop')
    AND revision1.rev_page IN (
    	SELECT page2.page_id
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
        INNER JOIN flaggedpage_pending AS flaggedpage_pending2 ON page2.page_id = flaggedpage_pending2.fpp_page_id
        INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
        INNER JOIN user AS user2 ON revision2.rev_actor = user2.user_id
      	WHERE page1.page_id = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending2.fpp_pending_since
      	AND (SELECT ug_user FROM user_groups AS user_groups2 WHERE user_groups2.ug_user = user2.user_id) IS NULL
    )
GROUP BY page1.page_title
ORDER BY revision1.rev_timestamp DESC;
SQL

Checking query status...
