use arwiki_p;

select #cl_sortkey_prefix AS " item ",

    #    (SELECT page_title FROM frwiki_p.page enp WHERE enp.page_namespace = 0 and enp.page_title= aa.page_title) AS "Page" ,

         CONCAT('Sarwiki') as "S" ,

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

#FROM  categorylinks 

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

#page_namespace, page_title, cl_sortkey_prefix, COUNT(*)

#JOIN arwiki_p.page

FROM page as aa, page_props as pp#, wikidatawiki_p.page as wdp

WHERE aa.page_namespace = 0

and pp.pp_value is null

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