Number of pages that link to a page

SQL

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

# pagelinks, categorylinks
SELECT COUNT(DISTINCT pl_from), SUM(NOT direct), SUM(direct) FROM (
  	# INDIRECT SELECT START
	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 = '')
  	# INDIRECT SELECT END
	UNION ALL
  	SELECT pl_from, 1 AS direct FROM pagelinks
	# DIRECT WHERE START 
	WHERE pl_title = 'Toronto' AND pl_namespace = 0
  	# DIRECT WHERE END
) AS temp;

# templatelinks, imagelinks
# SELECT COUNT(DISTINCT tl_from), COUNT(DISTINCT indirect_from), COUNT(DISTINCT tl_from) - COUNT(DISTINCT indirect_from) FROM templatelinks
SELECT COUNT(DISTINCT tl_from), SUM(NOT direct), SUM(direct) FROM templatelinks
LEFT JOIN (
	# INDIRECT SELECT START
	SELECT DISTINCT tl_from AS indirect_from, 0 AS direct 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 = '')
  	# INDIRECT SELECT END
) AS temp ON tl_from = indirect_from
# DIRECT WHERE START
WHERE tl_title = 'WikiProject_Canada_Streets' AND tl_namespace = 10;
# DIRECT WHERE END
SQL

Checking query status...
