Gilgamesh new draft

SQL

use hewiki_p;
select page_title as 'שם הערך', page_len as 'גודל', page_restrictions as 'הגנות' from page
where page_len > 40000
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 = "עריכה"
     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 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 "%מניין%"
and page_is_redirect = 0
and page_namespace = 0
and not page_id in (1069, 487670, 696339, 1291525)
SQL

Checking query status...
