SELECT *

from page

left join linktarget on lt_id = page_id

left join templatelinks on lt_id = tl_target_id and tl_from_namespace = 0

where page_namespace = 106

​

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