All links to a page

SQL

USE enwiki_p;
SELECT COUNT(*) AS plinks FROM pagelinks WHERE pl_namespace=0 AND pl_title="List_of_diplomatic_missions_of_Saint_Kitts_and_Nevis";

SELECT COUNT(*) AS `plinks from redirects` FROM redirect
	JOIN page ON rd_from=page_id
	JOIN pagelinks ON pl_namespace=page_namespace AND pl_title=page_title
    WHERE rd_namespace=0 AND rd_title="List_of_diplomatic_missions_of_Saint_Kitts_and_Nevis";

SELECT COUNT(*) as rlink FROM redirect WHERE rd_namespace=0 AND rd_title="List_of_diplomatic_missions_of_Saint_Kitts_and_Nevis";

SELECT COUNT(*) AS tlinks FROM templatelinks WHERE tl_namespace=0 AND tl_title="List_of_diplomatic_missions_of_Saint_Kitts_and_Nevis";

# Specific to file namespace
SELECT COUNT(*) AS flinks FROM imagelinks WHERE il_to="Toronto,_City_of.svg";

# Specific to category namespace
SELECT COUNT(*) AS clinks FROM categorylinks WHERE cl_to="Baron Wolfgang von Strucker (circa 1993).png";

SELECT COUNT(*) AS `clinks from redirects` FROM redirect
	JOIN page ON rd_from=page_id
	JOIN imagelinks ON pl_namespace=6 AND il_to=page_title
    WHERE rd_namespace=6 AND rd_title="Baron Wolfgang von Strucker (circa 1993).png";
SQL

Checking query status...
