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 

order by count(*) desc

;