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',
            lg.*
		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
            JOIN logging_logindex ON log_namespace = page_namespace AND log_title = page_title
		WHERE
			ptrp_reviewed = 0
			AND ptrpt_tag_id = 9
			AND page_namespace = 0
			AND page_is_redirect = 1
            AND EXISTS (
              # Only 1 revision
              SELECT 1
              FROM pagetriage_page_tags tags2
              WHERE tags2.ptrpt_page_id = page_id
              AND tags2.ptrpt_tag_id = 7
              AND tags2.ptrpt_value = 1
            )
            AND ug_group = 'extendedmover'
LIMIT 10;

#SELECT ptp.*, ptpt.*, ptt.* FROM pagetriage_page ptp
#			JOIN pagetriage_page_tags ptpt ON ptrp_page_id = ptrpt_page_id
#            JOIN pagetriage_tags ptt ON ptrt_tag_id = ptrpt_tag_id
#            WHERE ptrp_page_id = 75025628;
            #AND ptrt_tag_name = 'rev_count';

SELECT * FROM logging_logindex
WHERE log_namespace = 0 AND log_title = 'Hemlock_Semiconductor_Corporation'
LIMIT 10;

SELECT * FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE rev_page = 75025628
SQL

Checking query status...
