Page movers' redirects

SQL

		SELECT
			page_id AS 'pageid',
			page_title AS 'title',
			ptrpt_value AS 'target',
			actor_name AS 'creator',
            ug_group AS 'group'
		FROM
			page
			JOIN pagetriage_page ON page_id = ptrp_page_id
			JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id
			JOIN revision ON page_latest = rev_id
			JOIN actor ON rev_actor = actor_id
            JOIN user_groups ON actor_user = ug_user
		WHERE
			ptrp_reviewed = 0
			AND ptrpt_tag_id = 9
			AND page_namespace = 0
			AND page_is_redirect = 1
            AND ug_group NOT IN ('sysop', 'extendedconfirmed', 'reviewer')
LIMIT 10
SQL

Checking query status...
