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="Baron_Wolfgang_von_Strucker_(circa_1993).png";

# Specific to category namespace
SELECT COUNT(*) AS clinks FROM categorylinks WHERE cl_to="Toronto";

/*
SELECT COUNT(*) AS `clinks from redirects` FROM redirect
	JOIN page ON rd_from=page_id
	JOIN imagelinks ON il_to=page_title
    WHERE rd_namespace=6 AND rd_title="Baron_Wolfgang_von_Strucker_(circa_1993).png";
*/

SELECT * FROM redirect
	JOIN page ON rd_from=page_id
	JOIN imagelinks ON il_to=page_title
    WHERE rd_namespace=6 AND rd_title="Baron_Wolfgang_von_Strucker_(circa_1993).png"
SQL

Checking query status...
