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 like 'http://%.archive.'  
                                   or el_to_domain_index like 'http://%.archive.')
                             and not el_to_domain_index = 'https://org.archive.'
                             and not el_to_domain_index = 'http://org.archive.'
    and  (el_to_path not  like '/______________/http%' and el_to_domain_index = 'https://today.archive.')
SQL

Checking query status...
