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 DISTINCT pl_from FROM pagelinks
WHERE pl_title = 'Toronto' AND pl_namespace = 0
FULL OUTER JOIN (
  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 = '')
) AS 'temp'
SQL

Checking query status...
