Articles which have Taxoboxes and link to Surname pages

SQL

SET STATEMENT max_statement_time=100 FOR
SELECT Pt.page_title, Ps.page_title
FROM (SELECT cl_from FROM categorylinks WHERE cl_to='Surnames' AND cl_type='page' AND cl_from=1683750) CL
STRAIGHT_JOIN page Ps ON Ps.page_id=CL.cl_from AND Ps.page_namespace=0
STRAIGHT_JOIN pagelinks ON pl_title=Ps.page_title AND pl_from_namespace=0 AND pl_namespace=0
STRAIGHT_JOIN templatelinks ON tl_from=pl_from AND tl_title="Taxobox" AND tl_from_namespace=0 AND tl_namespace=10
STRAIGHT_JOIN page Pt ON Pt.page_id=pl_from
LIMIT 10;

SQL

Checking query status...