Untitled query #74017

SQL

SELECT indirect.pl_title
FROM page AS main
JOIN pagelinks AS direct ON pl_from = main.page_id AND direct.pl_namespace = 0
JOIN page AS redirects ON direct.pl_title = redirects.page_title AND redirects.page_namespace = 0 AND redirects.page_is_redirect = 1
JOIN pagelinks AS indirect ON indirect.pl_from = redirects.page_id AND indirect.pl_namespace = 0
JOIN page AS articles ON articles.page_title = indirect.pl_title AND articles.page_namespace = 1 AND articles.page_is_redirect = 0
JOIN categorylinks ON cl_from = articles.page_id AND cl_to LIKE '%iography%'
WHERE main.page_title = "Aaron_Harris"
AND main.page_namespace = 0
AND main.page_is_redirect = 0
SQL

Checking query status...
