use hewiki_p;

select concat('משתמש:',p.page_title) as TITLE, cl_to as CATEGORY from categorylinks inner join page cat

on cat.page_namespace=10

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')

order by cl_to;

select * from categorylinks inner join page p

on p.page_id=cl_from

where p.page_namespace = 2

and p.page_title = "Shirible/טיוטה"

​