Number of pages that link to a page

SQL

# redirect
SELECT DISTINCT COUNT(rd_from) FROM redirect
WHERE rd_title = 'Toronto' AND rd_namespace = 0 AND (rd_interwiki IS NULL OR rd_interwiki = '');

# pagelinks, categorylinks
SELECT COUNT(DISTINCT pl_from) - 43, SUM(NOT direct), SUM(direct) - 43 FROM (
	SELECT DISTINCT pl_from, 0 AS direct FROM redirect
	JOIN page AS target ON target.page_id = rd_from
	JOIN pagelinks ON pl_title = target.page_title AND pl_namespace = target.page_namespace
	WHERE rd_namespace = 0 AND rd_title = 'Toronto' AND (rd_interwiki IS NULL OR rd_interwiki = '')
	UNION ALL
  	SELECT pl_from, 1 AS direct FROM pagelinks
	WHERE pl_title = 'Toronto' AND pl_namespace = 0
) AS temp;

# templatelinks, imagelinks
SELECT COUNT(DISTINCT direct), COUNT(DISTINCT tl_from), COUNT(DISTINCT direct) - COUNT(DISTINCT tl_from) FROM redirect
JOIN page AS target ON target.page_id = rd_from
JOIN templatelinks ON tl_title = target.page_title AND tl_namespace = target.page_namespace
RIGHT JOIN (
	SELECT tl_from AS direct FROM templatelinks
	WHERE tl_title = 'WikiProject_Canada_Streets' AND tl_namespace = 10
) AS temp ON tl_from = direct AND rd_namespace = 10 AND rd_title = 'WikiProject_Canada_Streets' AND (rd_interwiki IS NULL OR rd_interwiki = '');

# templatelinks, imagelinks
SELECT COUNT(DISTINCT tl_from), COUNT(DISTINCT indirect), COUNT(DISTINCT tl_from) - COUNT(DISTINCT indirect) FROM templatelinks
LEFT JOIN (
	# INDIRECT SELECT
	SELECT DISTINCT tl_from AS indirect FROM redirect
	JOIN page AS target ON target.page_id = rd_from
	JOIN templatelinks ON tl_title = target.page_title AND tl_namespace = target.page_namespace
	WHERE rd_title = 'WikiProject_Canada_Streets' AND (rd_interwiki IS NULL OR rd_interwiki = '')
) AS temp ON tl_from = indirect
# DIRECT WHERE
WHERE tl_title = 'WikiProject_Canada_Streets' AND tl_namespace = 10;

# current
SELECT COUNT(pl_from) - 43, COUNT(indirect), COUNT(pl_from) - COUNT(indirect) - 43 FROM (
	SELECT pl_from, 1 AS indirect FROM redirect
	JOIN page AS target ON target.page_id = rd_from
	JOIN pagelinks ON pl_title = target.page_title AND pl_namespace = target.page_namespace
	WHERE rd_namespace = 0 AND rd_title = 'Toronto' AND (rd_interwiki IS NULL OR rd_interwiki = '')
	UNION ALL
  	SELECT pl_from, NULL AS indirect FROM pagelinks
	WHERE pl_title = 'Toronto' AND pl_namespace = 0
) AS temp;
SQL

Checking query status...
