Page movers' redirects

SQL

SELECT
	page_id AS 'pageid',
	page_title AS 'title',
	ptrpt_value AS 'target',
	actor_name AS 'creator'
FROM
	page
	JOIN pagetriage_page ON page_id = ptrp_page_id
	JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id
	JOIN revision rv 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 # Snippet
	AND page_namespace = 0
	AND page_is_redirect = 1
	AND EXISTS (
		# Only 1 revision based on rev_count page triage tag
		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 EXISTS (
		# Move log from the same time by the same person
		SELECT 1
		FROM logging_logindex lgl2
		WHERE log_namespace = page_namespace
		AND log_title = page_title
		AND log_timestamp = rev_timestamp
		AND log_actor = rev_actor
		AND log_type = 'move'
		AND log_action = 'move'
	)
	AND ug_group = 'extendedmover'

LIMIT 100;

#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...
