Gilgamesh draft 2023

SQL

select replace(page_title, '_', ' ') as name, page_len as length from page
where not page_namespace
and page_len >= 45*1024
and exists
(select * from templatelinks join linktarget
 where tl_from = page_id
 and tl_target_id = lt_id
 and lt_title = 'הערות_שוליים')
and not exists
(select * from templatelinks join linktarget
 where tl_from = page_id
 and tl_target_id = lt_id
 and lt_title in ('בעבודה', 'קצרמר', 'עריכה', 'להשלים', 'אקטואלי', 'לשכתוב', 'ערך_מומלץ'))
order by page_len asc
SQL

Checking query status...
