Taxonomy page - Quarry

SQL

use arwiki_p;
select #cl_sortkey_prefix AS " item ",
	 	 CONCAT('',  (SELECT * FROM frwiki_p.page enp WHERE enp.page_namespace = 0 and enp.page_title= aa.page_title)) AS  O ,
		 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;
SQL

Checking query status...
