SELECT *

from page

left join linktarget on lt_id = page_id and lt_namespace = page_namespace

left join templatelinks on lt_id = tl_target_id and tl_from_namespace = 0

where 

#page_namespace = 106 and 

page_content_model = "proofread-index"

#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"

limit 100;