Pages in pagelinks (ns=0) redirecting to "United States"

SQL

# 1. 'redirects' leading to "United_States"
#    alt: 'pagelinks' leading to "United_States" JOIN 'page.is_redirect'
#    Compare speed and resultset!
# 2. Count in 'pagelinks' the titles from resultset #1
# 3. Create a sum of count field from #2

SELECT
  pl_title AS title,
  COUNT(1) as refcount
FROM
  pagelinks
WHERE
  pl_namespace = 0
  AND pl_from_namespace = 0
  AND (
    pl_title = "United_States"
    OR pl_title = "'merica"
    OR pl_title = "'murica"
  )
GROUP BY
  title

#SELECT
#	t_
#  	,r.refs
#from foo as t
#left join (
#    select 
#    	title
#    	,count(*) as refs
#   	from foo
#) as r
#on t.title = r.title;

SQL

Checking query status...