set @ns_strona = 100;

set @ns_indeks = 102;

​

set @target_ns = @ns_indeks;

set @target_title = "Józef_Ignacy_Kraszewski_-_Piękna_pani.djvu";

​

select

    p_strona.page_id,

    p_strona.page_title

from page as p_strona

    left join linktarget as linktarget_strona

        on linktarget_strona.lt_namespace = @ns_strona and linktarget_strona.lt_title = p_strona.page_title

    left join templatelinks as templatelinks_strona

        on templatelinks_strona.tl_target_id = lt_id

    left join pagelinks as pagelinks_strona

        on pagelinks_strona.pl_namespace = @ns_strona and pagelinks_strona.pl_title = p_strona.page_title

where

    (templatelinks_strona.tl_from is not null and templatelinks_strona.tl_from_namespace = @ns_indeks and (

      select page_id

      from pagelinks as pagelinks_tl

      where

        pagelinks_tl.pl_from = templatelinks_strona.tl_from and

        pagelinks_tl.pl_namespace = @target_ns and

        pagelinks_tl.pl_title = @target_title

    ) is not null)

    or

    (pagelinks_strona.pl_from is not null and pagelinks_strona.pl_from_namespace = @ns_indeks and (

      select page_id

      from pagelinks as pagelinks_tl

      where

        pagelinks_tl.pl_from = pagelinks_strona.pl_from and

        pagelinks_tl.pl_namespace = @target_ns and

        pagelinks_tl.pl_title = @target_title

    ) is not null)

;