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

;