Improved project-specific inlink query

SQL

USE enwiki_p;

SELECT page_id,
       links.numlinks + IFNULL(redirlinks.numlinks, 0) AS num_inlinks
FROM
(SELECT p.page_id AS page_id,
        count(*) AS numlinks
     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)
     LEFT JOIN redirect
     ON lp.page_id=rd_from
     LEFT JOIN page tp
     ON (lp.page_title=tp.page_title
         AND 1=tp.page_namespace)
     LEFT JOIN categorylinks cl
     ON (tp.page_id=cl.cl_from)
     WHERE p.page_id IN (30474802, 2557186, 22939867, 20712038, 22678539, 21040259, 40832620,
                         21081377, 28774397, 20779111, 8524927, 21894306, 21894387, 22877614, 20672772,
                         23665522, 25239240, 22851691, 18883277, 23733207, 28452168, 18818832,
                         49183967,20851187, 10824283)
     AND rd_from IS NULL
     AND pl.pl_from_namespace=0
     AND cl.cl_to='All_WikiProject_Medicine_articles'
     GROUP BY p.page_id
) AS links
LEFT JOIN
(SELECT p1.page_id,
	    count(*) AS numlinks
 FROM page p1
 JOIN redirect 
 ON (p1.page_namespace=rd_namespace
     AND page_title=rd_title)
 JOIN page p2
 ON rd_from=p2.page_id
 JOIN pagelinks pl
 ON (p2.page_namespace=pl.pl_namespace
     AND p2.page_title=pl.pl_title)
 JOIN page tp
 ON (p2.page_title=tp.page_title
     AND 1=tp.page_namespace)
 JOIN categorylinks cl
 ON (tp.page_id=cl.cl_from)
 WHERE p2.page_namespace=0
 AND pl.pl_from_namespace=0
 AND p1.page_id IN (30474802, 2557186, 22939867, 20712038, 22678539, 21040259, 40832620,
                         21081377, 28774397, 20779111, 8524927, 21894306, 21894387, 22877614, 20672772,
                         23665522, 25239240, 22851691, 18883277, 23733207, 28452168, 18818832,
                         49183967,20851187, 10824283)
 AND cl.cl_to='All_WikiProject_Medicine_articles'
 GROUP BY page_id
) AS redirlinks
USING (page_id);
SQL

Checking query status...
