use arwiki_p;

select CONCAT('',page_title,'') AS "موجود في", cl_sortkey_prefix AS " الصفحة ", COUNT(*)  AS "عدد الاستخدامات",page_namespace

#page_namespace,  page_title, cl_sortkey_prefix, COUNT(*)

from categorylinks join page

on cl_from = page_id

where cl_to = "صفحات_ويكي_بيانات_بحاجة_لتسمية_عربية"

#and cl_sortkey_prefix like "مدينة%"

group by cl_sortkey_prefix# having count(*) > 1

ORDER BY  COUNT(*) DESC

#and page_title like "Mr._Ibrahem/%"

limit 50;