#use arwiki_p;

select cl_sortkey_prefix AS " item "

        , CONCAT('Sarwiki') as "S"

        , CONCAT('', page_title,'') AS "Page"

FROM  categorylinks 

#, COUNT(*) AS "عدد الاستخدامات" ,page_namespace

#page_namespace, page_title, cl_sortkey_prefix, COUNT(*)

#JOIN arwiki_p.page

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