use enwiki_p;

SELECT page_title FROM (

  SELECT tl_from, rd_from

  FROM `templatelinks`

    LEFT JOIN `redirect`

        ON ((rd_from = tl_from) AND rd_title = 'WikiProject_Chemistry' 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_Chemistry'

  ORDER BY tl_from)

`temp_backlink_range` INNER JOIN `page` ON ((tl_from = page_id)) WHERE page_namespace = '1' ORDER BY page_title;