archive-today worklist

SQL

SET sql_mode='PIPES_AS_CONCAT';
select  '# ' || el_to_domain_index|| 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...
