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), COUNT(indirect), COUNT(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`;

# Direct (unique) + indirect (unique), indirect
SELECT COUNT(pl_from), COUNT(indirect) 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...
