archive-is shorturls

SQL

select CONCAT( '# ' , count(*),' :', /*, 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 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 (el_to_path like '/_____' 
     or el_to_path like '/_____#select%' 
     or el_to_path like '/______' 
     or el_to_path like '/______#select%' ) 
group by page_title , el_to_path
;
SQL

Checking query status...
