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);