Unreviewed changes by trusted users

SQL

USE huwiki_p;
SELECT page1.page_title, GROUP_CONCAT(DISTINCT actor.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_pending.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 ON ug_user = actor_user
WHERE TRUE #page1.page_id = 29709
    AND revision.rev_timestamp >= fpp_pending_since
    AND ug_group IN ('editor','trusted','sysop')
GROUP BY page1.page_title
ORDER BY revision.rev_timestamp DESC;
SQL

Checking query status...
