SQL
x
USE arwiki_p;
SELECT CONCAT('# [[:تصنيف:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to
FROM page, categorylinks
WHERE page_id = cl_from
#AND page_namespace = 0
AND cl_to REGEXP 'مقالات_(.*)_غير_مقيمة_(.*)_الأهمية'
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE cl_to = p1.page_title
AND p1.page_namespace = 14)
GROUP BY cl_to
ORDER BY count_cl_to DESC, cl_to ASC;
USE arwiki_p;
SELECT CONCAT('# [[:تصنيف:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to
FROM page, categorylinks
WHERE page_id = cl_from
#AND page_namespace = 0
AND cl_to REGEXP 'مقالات_(.*)_حسب_الجودة_والأهمية'
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE cl_to = p1.page_title
AND p1.page_namespace = 14)
GROUP BY cl_to
ORDER BY count_cl_to DESC, cl_to ASC;
USE arwiki_p;
SELECT CONCAT('# [[:تصنيف:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to
FROM page, categorylinks
WHERE page_id = cl_from
#AND page_namespace = 0
AND cl_to REGEXP 'مقالات_(.*)_ذات_صنف_(.*)_الأهمية'
AND cl_to NOT REGEXP 'مقالات_(.*)_ذات_صنف_غير_مقالية_(فائقة|عالية|متوسطة|قليلة|ضئيلة|غير_معروفة)_الأهمية'
AND cl_to NOT REGEXP 'مقالات_(.*)_ذات_صنف_(بذرة|بداية)_غير_مطبقة_الأهمية'
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE cl_to = p1.page_title
AND p1.page_namespace = 14)
GROUP BY cl_to
ORDER BY count_cl_to DESC, cl_to ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.