Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Nehaoua
.
Toggle Highlighting
SQL
DESCRIBE templatelinks; SELECT #page_title, tl_title p.page_title, COUNT(tl_from) FROM templatelinks t join page p on p.page_id = t.tl_from INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = 'جميع_المقالات_التي_بحاجة_لصيانة' where t.tl_from_namespace = 10 AND t.tl_from IN ("يتيمة", "مصدر", "مصادر_أكثر", "نهاية_مسدودة", "وصلات_قليلة", "دمج", "غير_مصنفة", "تفخيم", "حيادية", "ترجمة", "إعادة_كتابة", "تهذيب", "تدقيق_لغوي", "تدقيق_إملائي", "بحاجة_لمصدر", "مقالات_بحاجة_لتحديث_المصادر", "وصلة_مكسورة", "تحديث", "تنسيق", "توسيع", "قسم_فارغ", "غير_مراجعة") and tl_from_namespace=0 and page_is_redirect=0 GROUP BY p.page_title ORDER BY COUNT(t.tl_from) DESC LIMIT 300
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
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...