SELECT *

from page p1

left join linktarget on p1.page_namespace = lt_namespace and p1.page_title = lt_title

left join templatelinks # on page_id = tl_target_id #and tl_from_namespace = 0

on lt_id = tl_target_id #on lt_id = page_id #and lt_namespace = page_namespace

left join page p2 on p2.page_id = tl_from and tl_namespace = 0

where 

#page_namespace = 106 and 

p1.page_content_model = "proofread-index"

#and tl_from is null

#page_content_model = "proofread-page"

#FROM templatelinks

#WHERE tl_target_id = 1706714;              

#INNER JOIN linktarget ON tl_target_id = lt_id

#inner join page on page_id = tl_from

#WHERE lt_namespace = "106"

#and p1.page_id = 182196

limit 100;