Hewiki user namespace pages with categories

SQL

use hewiki_p;
select concat('משתמש:',p.page_title) as TITLE, cl_to as category from categorylinks inner join page cat
on cat.page_namespace=14
and cat.page_title=cl_to
inner join page p
on p.page_id=cl_from
where p.page_namespace=2
and cl_to not like 'User_%'
and not exists
(select * from page_props
 where pp_page=cat.page_id
 and pp_propname='hiddencat')
and p.page_title like "%/%"
and not exists
(select * from categorylinks as cat1
 where cat1.cl_from = cat.page_id
 and cat1.cl_to = "ניהול_פרמטרים")
and not cl_to in ("דפים_להעברה_לוויקיספר")
order by cl_to

SQL

Checking query status...