WPMED redirects

SQL

USE enwiki_p;

SELECT count(*) AS num_redirects_wpmed
FROM page p
JOIN pagelinks pl
ON (p.page_namespace=pl.pl_namespace
    AND p.page_title=pl.pl_title)
JOIN page lp
ON (lp.page_id=pl.pl_from)
JOIN page tp
ON (lp.page_title=tp.page_title
    AND tp.page_namespace=1)
JOIN categorylinks cl
ON (tp.page_id=cl.cl_from)
WHERE pl.pl_from_namespace=0
AND lp.page_is_redirect=1
AND cl.cl_to = "All_WikiProject_Medicine_articles";

SELECT count(*) AS num_redirects
FROM page p
JOIN pagelinks pl
ON (p.page_namespace=pl.pl_namespace
    AND p.page_title=pl.pl_title)
JOIN page lp
ON (lp.page_id=pl.pl_from)
JOIN page tp
ON (lp.page_title=tp.page_title
    AND tp.page_namespace=1)
WHERE pl.pl_from_namespace=0
AND lp.page_is_redirect=1;
SQL

Checking query status...
