Some needed articles

Fork of quality of articles in 'History_of_Essex' category by Ladsgroup

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

SQL

use s51100__wikiproject;
use enwiki_p;
SELECT page_title, wikis FROM (
  SELECT tl_from, rd_from
  FROM enwiki_p.templatelinks
  	LEFT JOIN enwiki_p.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 enwiki_p.page
  		ON ((tl_from = page_id))
  WHERE
  	tl_namespace = '10' AND
  	tl_title = 'WikiProject_Medicine'
  ORDER BY tl_from)
`temp_backlink_range` INNER JOIN enwiki_p.page ON ((tl_from = page_id)) INNER JOIN needed_articles on page_name = page_title WHERE page_namespace = '1' ORDER BY wikis;
LIMIT 50;

SQL

Checking query status...