use arwiki_p;

select CONCAT('A') as "تجاهل" ,CONCAT('',page_title,'') AS "مثال صفحة", cl_sortkey_prefix AS " item "

#, 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;