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_title = 'Dane_tekstu' AND

               lt2.lt_namespace = 10 AND lt2.lt_title = 'PD-symbol' AND

               lt3.lt_namespace = 10 AND lt3.lt_title = 'PD-symbol'

​

LIMIT 300;

;