SQL
x
use hewiki_p;
select distinct(concat('משתמש:',p.page_title)) from categorylinks inner join page cat#, cl_to as category
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 = "ניהול_פרמטרים"
or cat1.cl_to like "ויקיפדיה_%"))
and not cl_to in ("דפים_להעברה_לוויקיספר", "דפים_עם_תרשימים_מיושנים_של_Vega_1.0", "תבניות_תמונות_משתמש")
and not cl_to like "ויקיפדיה/בוט/%"
and not cl_to like "ויקיפדיה_%"
and not cl_to like "משתמשים_רשומים_ב%"
and not cl_to like "תמונות_מוויקיפדיה%"
and not p.page_title in ("בורה_בורה/תבנית_עיר", "בורה_בורה/תבניות", "Hanay/כללי")
and not cl_to = "תבניות_לא_לשימוש"
order by cl_to
#check
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.