Untitled query #37395

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

SQL

SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON rd_from = page_id
WHERE
  page_namespace = 118
  AND page_is_redirect = 1
GROUP BY rd_namespace
ORDER BY num_to_NS DESC

AخA
 
SELECT rd_namespace, COUNT(*) AS num_to_NSFROM pageLEFT JOIN redirect ON rd_from = page_idWHERE  page_namespace = 118  AND page_is_redirect = 1GROUP BY rd_namespaceORDER BY num_to_NS 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...