Unreviewed files from GODL-India breakdown

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

SQL

SELECT
  cl_to AS category,
  COUNT(DISTINCT cl.cl_from) AS file_count
FROM
  categorylinks AS cl
JOIN (
  SELECT
    page_id
  FROM
    page
  JOIN
    categorylinks
  ON
    page_id = cl_from
  WHERE
    cl_to = "Unreviewed_photos_of_GODL-India"
    AND page_namespace = 6
) AS godl_files
ON
  cl.cl_from = godl_files.page_id
WHERE
  cl_to != "Unreviewed_photos_of_GODL-India"
GROUP BY
  cl_to
ORDER BY
  file_count 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...