List of WP:MED articles with their langlinks

Fork of List of WP:MED articles with their langlinks by Ladsgroup

This query is marked as a draft This query has been published by TheresNoTime.

SQL

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;

SQL

Checking query status...