archive-today worklist

SQL

SET sql_mode='PIPES_AS_CONCAT';
select  '# ' || count(el_to_path) || ': {{Bearbeiten|'||page_title ||'|text='||page_title||'}}' as output 
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 and  (el_to_domain_index = 'http://today.archive.'  
                                  or el_to_domain_index = 'https://today.archive.'
                                  or el_to_domain_index like 'https://__.archive.'
                                  or el_to_domain_index like 'http://__.archive.')

)
and  (el_to_path not  like '/______________/http%' and el_to_domain_index = 'https://today.archive.')
SQL

Checking query status...
