use hewiki_p;

select * from page

where page_namespace = 0

and (exists

(select * from templatelinks

 where tl_from = page_id

 and tl_title = "ויקישיתוף_בשורה")

or (exists

(select * from templatelinks

 where page_id = tl_from

 and tl_title = 'מיזמים')

and not exists

(select * from categorylinks

 where page_id = cl_from

 and cl_to = 'ערכים_עם_תבנית_מיזמים_בלי_קטגוריות_ויקישיתוף')))

and not exists

(select * from imagelinks

 where page_id = il_from

 and not il_to in ('Wikipedia-logo-v2.svg', 'Wikipedia-logo-v2.svg', 'Wiktionary-logo-he.png', 'Wikiquote-logo.svg', 'Wikibooks-logo.svg', 

 'Wikisource-logo.svg', 'Wikinews-logo.svg', 'Commons-logo.svg', 'Wikimedia_Community_Logo.svg', 'MediaWiki_logo.png',

 'Wikivoyage-Logo-v3-icon_-_mirrored.svg', 'Wikivoyage-Logo-v3-icon_-_mirrored.svg', 'Wikispecies-logo.svg'))

and not page_title rlike '^[0-9]+$'

and not page_title rlike '_לפנה"ס$'

and not page_title rlike '^[0-9]+_בינואר$'

and not page_title rlike '^[0-9]+_בפברואר$'

and not page_title rlike '^[0-9]+_במרץ$'

and not page_title rlike '^[0-9]+_באפריל$'

and not page_title rlike '^[0-9]+_במאי$'

and not page_title rlike '^[0-9]+_ביוני$'

and not page_title rlike '^[0-9]+_ביולי$'

and not page_title rlike '^[0-9]+_באוגוסט$'

and not page_title rlike '^[0-9]+_בספטמבר$'

and not page_title rlike '^[0-9]+_באוקטובר$'

and not page_title rlike '^[0-9]+_בנובמבר$'

and not page_title rlike '^[0-9]+_בדצמבר$'

​