Untitled query #81683

SQL

USE ruwiki_p;

SELECT
    categorylinks.cl_to AS category,
    COUNT(*) AS article_count
FROM categorylinks
JOIN page ON categorylinks.cl_from = page_id
LEFT JOIN categorylinks AS talk_category ON categorylinks.cl_to = CONCAT('Обсуждение:', page_title)
WHERE categorylinks.cl_to LIKE 'Статьи_проекта_%'
    AND categorylinks.cl_type = 'page'
    AND page_namespace = 0
    AND talk_category.cl_to IS NULL
    AND NOT (categorylinks.cl_to LIKE '% важности' OR categorylinks.cl_to LIKE '% уровня' OR categorylinks.cl_to LIKE '% по уровню')
GROUP BY categorylinks.cl_to
HAVING article_count BETWEEN 0 AND 50;
SQL

Checking query status...
