Проект:Удаление статей/Малоиспользуемые юзербоксы

SELECT 
    CONCAT('[[Шаблон:', p.page_title, ']]') AS template_name,
    COUNT(pu.page_id) AS usage_count
FROM page p
LEFT JOIN linktarget lt ON p.page_title = lt.lt_title
LEFT JOIN templatelinks tl ON lt.lt_id = tl.tl_target_id
LEFT JOIN page pu ON pu.page_id = tl.tl_from AND pu.page_namespace = 2
WHERE p.page_namespace = 10
    AND p.page_title LIKE 'Userbox/%'
    AND p.page_title NOT LIKE '%/doc'
    AND p.page_title NOT LIKE '%/doc-template'
    AND p.page_title NOT LIKE '%/тесты'
    AND p.page_title NOT LIKE '%/песочница'
    AND p.page_is_redirect = 0
GROUP BY p.page_title
HAVING COUNT(pu.page_id) BETWEEN 0 AND 3
ORDER BY usage_count DESC;