الصفحات التي تحتوي على عدد كبير جدًا من قوالب الصيانة

SQL

SELECT page.page_title, COUNT(DISTINCT lt_title) as template_count
FROM page
JOIN templatelinks ON page.page_id = templatelinks.tl_from
JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
JOIN (
    SELECT DISTINCT cl_from
    FROM categorylinks
    WHERE cl_to LIKE "قوالب_صيانة_المحتوى"
    AND cl_type = "page"
    AND cl_sortkey = ""
) AS category ON page.page_id = category.cl_from
WHERE page.page_namespace = 0
GROUP BY page.page_title
HAVING template_count > 3
ORDER BY template_count DESC
LIMIT 100;

SQL

Checking query status...