archive-today worklist

SQL

/*SET sql_mode='PIPES_AS_CONCAT';*/

select CONCAT( '# ' , count(*) , /*el_to_domain_index , el_to_path , */ ': {{Bearbeiten|',page_title ,'|text=',page_title,'}}') as output 
/*  
SELECT count(*), el_to_domain_index 
  */
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 
and  (el_to_domain_index in (
  /*'https://fo.archive.',
'https://is.archive.',
'https://li.archive.',
'https://md.archive.',
'https://ph.archive.',
'https://today.archive.',
'https://vn.archive.',*/
'http://fo.archive.',
'http://is.archive.',
'http://li.archive.',
'http://md.archive.',
'http://ph.archive.',
'http://today.archive.',
'http://vn.archive.') ) 
and not (el_to_domain_index  =  'https://today.archive.' and el_to_path like '/______________/http%')
group by page_title
order by count(*) desc
;
SQL

Checking query status...
