Empty categories linking to redlinked templates

SQL

/* Value for pagetriage_page.ptrp_reviewed for autopatrol */
SET @autopatrol_status = 3;

/* Value for global_user_groups.gug_user for global rollbackers */
SET @global_group = 'global-rollbacker';

SELECT
	pg.page_id AS 'Target page id',
    gu.gu_name AS 'Creator (name)',
    a.actor_user AS 'Creator (user id)',
    ptrp.*,
    pg.*
FROM centralauth_p.global_user_groups gug
JOIN centralauth_p.globaluser gu
	ON gu.gu_id = gug.gug_user
JOIN actor a
	ON a.actor_name = gu.gu_name
JOIN pagetriage_page ptrp
	ON ptrp.ptrp_last_reviewed_by = a.actor_user
JOIN page pg
	ON pg.page_id = ptrp.ptrp_page_id
WHERE gug.gug_group = @global_group

/* Global rollbackers can be new page reviewers, only care about pages that they autopatrolled */
AND ptrp.ptrp_reviewed = @autopatrol_status

/* The focus is on articles, global rollbackers can be trusted not to abuse user pages */
AND pg.page_namespace = 0

/* Global rollbackers can also be locally autopatrolled. Exclude users in the relevant local groups */
AND NOT EXISTS (
	SELECT 1
	FROM user_groups ug
	WHERE ug.ug_user = a.actor_user
	AND ug.ug_group IN ('autoreviewer', 'sysop')
)
SQL

Checking query status...
