Unreviewed changes by trusted users

SQL

USE huwiki_p;
SELECT page.page_title, GROUP_CONCAT(actor.actor_name) AS 'user'#, GROUP_CONCAT(user_groups.ug_group) AS 'jogok'
FROM page#, user_groups
INNER JOIN revision ON page.page_id = revision.rev_page
INNER JOIN flaggedpage_pending ON page.page_id = flaggedpage_pending.fpp_page_id
INNER JOIN actor ON revision.rev_actor = actor.actor_id
INNER JOIN user ON revision.rev_actor = user.user_id
LEFT OUTER JOIN user_groups ON ug_user = actor_user
WHERE TRUE #page.page_id = 29709
    AND revision.rev_timestamp >= fpp_pending_since
    AND ug_group IN ('editor','trusted','sysop')
GROUP BY actor_name, page.page_title
ORDER BY revision.rev_timestamp DESC;
SQL

Checking query status...
