Core enwp finder nonperformant

SQL

SET @ARTICLE_SPACE = 0;
SET @START_PAGEID=13692155; # 'Philosophy'

# this finds articles N links away from START
select p1.page_title as 'page_1', p1.page_id as 'p1_pageid', p2.page_title as 'page_2', p2.page_id as 'p2_pageid'
from page as p1
join page as p2
  on p2.page_title in (select pl_title from pagelinks where pl_namespace=@ARTICLE_SPACE and pl_from=p1.page_id) 
where p1.page_title in (select pl_title from pagelinks where pl_namespace=@ARTICLE_SPACE and pl_from=@START_PAGEID) 
  and @START_PAGEID != p1.page_id
  and @START_PAGEID != p2.page_id
  and p1.page_id != p2.page_id
  and p1.page_random < 0.001
  and p2.page_random < 0.001
limit 3;
SQL

Checking query status...
