USE plwikisource_p;

SELECT lt1.lt_id, lt2.lt_id, lt3.lt_id, lt1.lt_namespace, lt1.lt_title, lt2.lt_title, lt3.lt_title, tl1.tl_from, page.page_title

​

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

INNER JOIN templatelinks tl2 on tl1.tl_from=tl2.tl_from

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

INNER JOIN templatelinks tl3 on tl1.tl_from=tl3.tl_from

INNER JOIN linktarget lt3 on tl3.tl_target_id = lt3.lt_id

INNER JOIN page on page.page_id = tl1.tl_from 

WHERE

               lt1.lt_namespace = 10 AND lt1.lt_id = (SELECT page_id FROM page WHERE page_title = 'Dane_tekstu' AND page_namespace = '10') AND

               lt2.lt_namespace = 10 AND lt2.lt_id = '3730' AND

               lt3.lt_namespace = 10 AND lt3.lt_id = '455469'

​

LIMIT 300

;