Untitled query #87781

SQL

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

Checking query status...
