Taxonomy page - Quarry

SQL

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

Checking query status...
