use arwiki_p;

select #cl_sortkey_prefix AS " item ",

    #    CONCAT('',  enp.page_title AS "Page",

         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

FROM page aa

WHERE aa.page_namespace = 0

#join page 

#ON cl_from = page_id

#and cl_to = "صفحات_دون_عنصر_ويكي_بيانات/كائن"

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

#and exists (SELECT * FROM enwiki_p.page enp WHERE enp.page_namespace = 0 and enp.page_title=page_title)

and exists (SELECT * FROM frwiki_p.page enp WHERE enp.page_namespace = 0 and enp.page_title= aa.page_title)

​

#group by cl_sortkey_prefix# having count(*) > 1

#ORDER BY COUNT(*) DESC

#and page_title like "Mr._Ibrahem/%"

limit 50;