Test 3 - Quarry

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

SQL

USE enwiki_p;

WITH CategoryCounts AS (
  SELECT
    cl_to AS category_title,
    COUNT(DISTINCT ll_lang) AS language_count
  FROM categorylinks
  LEFT JOIN langlinks ON cl_from = ll_from
  WHERE cl_to NOT IN (
    SELECT
      ll_title
    FROM ckbwiki.langlinks
    WHERE ll_lang = 'en'
  )
  GROUP BY cl_to
  ORDER BY language_count DESC
  LIMIT 100
)

SELECT
  category_title
FROM CategoryCounts;

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...