USE plwikisource_p;

SELECT lt1.lt_id, lt2.lt_id, lt1.lt_namespace, lt1.lt_title, lt2.lt_title, page.page_id, page.page_title

​

FROM linktarget lt1 INNER JOIN templatelinks tl1 on tl1.tl_target_id = lt1.lt_id

INNER JOIN linktarget lt2 INNER JOIN templatelinks tl2 on tl2.tl_target_id = lt2.lt_id

INNER JOIN page on page.page_id = tl1.tl_from 

WHERE lt1.lt_namespace = 10 AND lt1.lt_id = '3730' AND lt2.lt_namespace = 10 AND lt2.lt_id = '12' AND tl1.tl_from=tl2.tl_from

​

LIMIT 300;

;