use hewiki_p;

select page_title as 'שם הערך', page_len as 'גודל', page_restrictions as 'הגנות' from page

where page_len > 30720

and exists

(select * from templatelinks

 where tl_from = page_id

 and tl_from_namespace = page_namespace

 and tl_title = "הערות_שוליים")

and not exists

(select * from templatelinks

 where tl_from = page_id

 and tl_from_namespace = page_namespace

 and (tl_title = "ערך_מומלץ" or tl_title = "לשכתב" or tl_title = "להשלים" or tl_title = "עריכה"))

and not page_title like "%רשימ%"

and not page_title like "%אירוויזיו%"

and not page_title like "%מונדיאל%"

and not page_title like "%אולימפ%"

and page_is_redirect = 0

and page_namespace = 0

​