Untitled query #81358

SQL

SELECT
  CONCAT('[[Категория:', cl_to, ']]') AS CategoryName,
  COUNT(DISTINCT CONCAT(page_namespace, ':', page_title)) AS PageCount
FROM categorylinks
LEFT JOIN page ON cl_from = page_id
WHERE page_namespace = 14 -- пространство имен для категорий
  AND cl_to NOT IN (
    SELECT DISTINCT CONCAT('Категория:', wdcl.cl_to)
    FROM categorylinks AS wdcl
    JOIN page AS wdp ON wdcl.cl_from = wdp.page_id
    WHERE wdp.page_namespace = 0 -- пространство имен для элементов викиданных
  )
GROUP BY cl_to
ORDER BY PageCount DESC;
SQL

Checking query status...
