archive-today worklist

SQL

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