Within WikiProject Biology in-links to :en:Biology and :en:Abdominal_cavity

SQL

SELECT "Biology" AS article, COUNT(article.page_id) AS within_articles, SUM(wplinked.pl_from IS NOT NULL) AS links_from_within
FROM categorylinks
INNER JOIN page talk ON
	cl_from = talk.page_id AND
    talk.page_namespace = 1
INNER JOIN page article ON
	talk.page_title = article.page_title AND
    article.page_namespace = 0
LEFT JOIN pagelinks AS wplinked ON
	article.page_id = pl_from AND
    pl_namespace = 0 AND
    pl_title = "Biology"
WHERE
	cl_to = "WikiProject_Biology_articles"
UNION ALL
SELECT "Abdominal_cavity" AS article, COUNT(article.page_id) AS within_articles, SUM(wplinked.pl_from IS NOT NULL) AS links_from_within
FROM categorylinks
INNER JOIN page talk ON
	cl_from = talk.page_id AND
    talk.page_namespace = 1
INNER JOIN page article ON
	talk.page_title = article.page_title AND
    article.page_namespace = 0
LEFT JOIN pagelinks AS wplinked ON
	article.page_id = pl_from AND
    pl_namespace = 0 AND
    pl_title = "Abdominal_cavity"
WHERE
	cl_to = "WikiProject_Biology_articles";
UNION ALL
SELECT "Abyssal_plain" AS article, COUNT(article.page_id) AS within_articles, SUM(wplinked.pl_from IS NOT NULL) AS links_from_within
FROM categorylinks
INNER JOIN page talk ON
	cl_from = talk.page_id AND
    talk.page_namespace = 1
INNER JOIN page article ON
	talk.page_title = article.page_title AND
    article.page_namespace = 0
LEFT JOIN pagelinks AS wplinked ON
	article.page_id = pl_from AND
    pl_namespace = 0 AND
    pl_title = "Abyssal_plain"
WHERE
	cl_to = "WikiProject_Biology_articles";
SQL

Checking query status...
