Wikimedia Bugzilla is closed!

I was using the Special:BrokenRedirects on my internal wiki installation when I
realize that I have too many broken redirects. I found out that the sql syntax
for join is wrong.

Current:
LEFT JOIN $page AS p2 ON (pl_namespace=p2.page_namespace AND
pl_title=p2.page_title AND p2.page_namespace IS NULL)

Should be:
LEFT JOIN $page AS p2 ON (pl_namespace=p2.page_namespace AND pl_title=p2.page_title)
WHERE p2.page_namespace IS NULL

The p2.page_namespace should be used as WHERE, not ON. I've test it in my local
installation and it shows the correct broken redirects.