Number of pages that link to a page

SQL

# SELECT DISTINCT pl_from 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 = '');
SELECT COUNT(DISTINCT pl_from) - 43 AS 'either (unique)', COUNT(indirect) AS 'indirect (unique)', COUNT(direct) - 43 AS 'direct' FROM (
	SELECT DISTINCT pl_from, 1 AS indirect, NULL 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 DISTINCT pl_from, NULL AS indirect, 1 AS direct FROM pagelinks
	WHERE pl_title = 'Toronto' AND pl_namespace = 0
) AS `temp`;

SELECT COUNT(DISTINCT tl_from) AS 'either (unique)', COUNT(indirect) AS 'indirect (unique)', COUNT(direct) AS 'direct' FROM (
	SELECT DISTINCT t1.tl_from, 1 AS indirect, NULL AS direct FROM redirect
	JOIN page AS target ON target.page_id = rd_from
	JOIN templatelinks AS t1 ON t1.tl_title = target.page_title AND t1.tl_namespace = target.page_namespace
  	JOIN templatelinks AS t2 ON t2.tl_from = t1.tl_from t2.tl_title = 'WikiProject_Canada_Streets' AND t2.tl_namespace = 0
	WHERE rd_namespace = 10 AND rd_title = 'WikiProject_Canada_Streets' AND (rd_interwiki IS NULL OR rd_interwiki = '')
	UNION ALL
  	SELECT DISTINCT tl_from, NULL AS indirect, 1 AS direct FROM templatelinks
	WHERE tl_title = 'WikiProject_Canada_Streets' AND tl_namespace = 0
) AS `temp`;

SELECT COUNT(pl_from) - 43 AS 'direct + indirect', COUNT(indirect) AS 'indirect', COUNT(pl_from) - COUNT(indirect) - 43 AS 'direct' 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...
