archive-is shorturls

SQL

select CONCAT( '# ' , /*, el_to_domain_index ,*/ el_to_path , GROUP_CONCAT( '  {{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 '/____' 
     or el_to_path like '/_____#select%' or el_to_path like '/____#select%' 
     or el_to_path not like '/20%'  ) 
and page_id not in (7787565,  2562559  ,7715059, 1643070 ,1397776)
group by el_to_path 
order by page_title
;
SQL

Checking query status...
