use hewiki_p;

select case when exists (select * from categorylinks where cl_from = page_id) then "cat" else "no" end as cat, page_title from page

where page_namespace = 10

and page_is_redirect = 0

and page_title like "%/%"

and not page_title like "%/פרמטרים"

and not page_title like "%/תיעוד"

and not page_title like "בוט_יישובים/%"

and not page_title like "דגל/%"

and not page_title like "דרגה/%"

and not page_title like "הודעת_עריכה/%"

and not page_title like "הנחיות_תמונה/%"

and not page_title like "ויקיפדיה%"

​