Untitled query #6805

SQL

use arwiki_p;
SELECT p.page_title, pp_value, GROUP_CONCAT(cl.cl_to SEPARATOR ', ')
FROM page p, page_props, categorylinks cl, wikidatawiki_p.page wdp
WHERE p.page_namespace = 0
and exists (select * from wikidatawiki_p.pagelinks wdpl3 where wdpl3.pl_from = wdp.page_id AND wdpl3.pl_title = 'Q5' AND wdpl3.pl_namespace = 0)
and not exists (select * from wikidatawiki_p.pagelinks wdpl2 where wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'P21' AND wdpl2.pl_namespace = 120)

AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0
	#AND cl.cl_from=p.page_id
       #             and (cl.cl_to rlike "female" or cl.cl_to rlike "wom[ae]n")
#AND wdpl2.pl_from IS NULL
group by p.page_id
limit 550;
SQL

Checking query status...
