Test 3 - Quarry

SQL

-- Query for enwiki_p (English Wikipedia)
USE enwiki_p;

-- Get the top 100 categories on enwiki that are not in ckbwiki
SELECT
  enwiki.category
FROM
(
  SELECT
    cl_to AS category,
    COUNT(*) AS count
  FROM
    categorylinks
  WHERE
    cl_to NOT IN (
      SELECT page_title
      FROM page
      WHERE page_id IN (
        SELECT cl_from
        FROM categorylinks
        WHERE cl_to = 'Hidden_categories'
      )
    )
  GROUP BY
    category
) AS enwiki
LEFT JOIN
(
  -- Subquery for ckbwiki categories
  USE ckbwiki_p;
  SELECT
    cl_to AS category
  FROM
    categorylinks
  GROUP BY
    category
) AS ckbwiki
ON enwiki.category = ckbwiki.category
WHERE ckbwiki.category IS NULL
LIMIT 100;
SQL

Checking query status...
