Fork of
صفحات_ويكي_بيانات_بحاجة_لتسمية_عربية
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by FShbib.
SQL
x
use arwiki_p;
select CONCAT('',page_title,'') AS "موجود في", cl_sortkey_prefix AS " الصفحة ", COUNT(*) AS "عدد الاستخدامات",page_namespace
from categorylinks join page
on cl_from = page_id
where cl_to = "صفحات_ويكي_بيانات_بحاجة_لتسمية_عربية"
group by cl_sortkey_prefix
ORDER BY COUNT(*) DESC
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.