use enwiki_p;

SELECT p1.page_title, ll_lang, ll_title FROM (

  SELECT tl_from, rd_from

  FROM `templatelinks`

    LEFT JOIN `redirect`

        ON ((rd_from = tl_from) AND rd_title = 'WikiProject_Medicine' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '10')

    INNER JOIN `page`

        ON ((tl_from = page_id))

  WHERE

    tl_namespace = '10' AND

    tl_title = 'WikiProject_Medicine'

  ORDER BY tl_from)

`temp_backlink_range`

INNER JOIN `page` p1 ON ((tl_from = p1.page_id))

inner join page p2 on (p1.page_title = p2.page_title)

inner join `langlinks` on ll_from = p2.page_id

WHERE p1.page_namespace = '1' and p2.page_namespace = '0'

ORDER BY page_title;