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(pl_from), COUNT(indirect IS NOT NULL) 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
	SELECT pl_from, NULL AS indirect FROM pagelinks
	WHERE pl_title = 'Toronto' AND pl_namespace = 0
) AS `temp`;
*/

SELECT pl_from FROM redirect
JOIN page AS target ON target.page_id = rd_from
JOIN pagelinks AS indirect ON indirect.pl_title = target.page_title AND indirect.pl_namespace = target.page_namespace
FULL JOIN pagelinks AS direct
WHERE (rd_namespace = 0 OR direct.pl_namespace = 0) AND (rd_title = 'Toronto' OR direct.pl_title = 'Toronto')
SQL

Checking query status...
