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

SQL

​x
 
SELECT 
    CONCAT('Категория:', cl.cl_to) AS category_link,   -- Формируем ссылку на категорию
    COUNT(cl.cl_from) AS article_count               -- Подсчитываем количество статей в категории
FROM 
    categorylinks cl
LEFT JOIN 
    page p ON p.page_title = cl.cl_to AND p.page_namespace = 14
WHERE 
    p.page_id IS NULL  -- Категория не существует
GROUP BY 
    cl.cl_to
HAVING 
    article_count > 0  -- Категория должна использоваться
ORDER BY 
    article_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
All SQL code is licensed under CC0 License.

Checking query status...