Broken Redirect

This query is marked as a draft This query has been published by MdsShakil.

Broken redirect

SQL

SELECT 
  rd_namespace, rd_title, COUNT(*) AS num_occurrences 
FROM 
  redirect 
  JOIN page ON rd_namespace = page_namespace AND rd_title = page_title
WHERE 
  rd_namespace = 0 AND page_id IS NULL 
GROUP BY 
  rd_namespace, rd_title 
ORDER BY 
  num_occurrences DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...