Untitled query #7093

SQL

use lvwiki_p;
select  iw.iwl_from, iw.iwl_title#, count(iw.iwl_title)
from iwlinks iw
join page p on iw.iwl_from=p.page_id
where exists (select *
		from categorylinks cla
		where iw.iwl_from=cla.cl_from and cla.cl_type="page" and cla.cl_to="P373:_nav_Vikidatos")
and p.page_namespace=0 and iwl_title like "Category:%"# and iwl_title not like "Wikipedia:%"
and iwl_prefix="commons"
and not exists (select * #concat('Category:',commonswiki_p.page_title)
		from commonswiki_p.page cp
		where cp.page_namespace=14 and cp.page_is_redirect=0 
                and iw.iwl_title=concat('Category:',cp.page_title))
#group by iw.iwl_title
#order by count(*) desc
SQL

Checking query status...
