SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.