with sq as (select el_to_domain_index as ipadr, CONCAT(   ' – '   , count(*)  , ' – '   , GROUP_CONCAT( ' –  {{Bearbeiten|',page_title ,'|text=',page_title,'}} – ' )  , el_to_path ) as suboutput 

FROM externallinks

JOIN page ON page_id = el_from

WHERE page.page_namespace =0 

And (el_to_domain_index like 'https://V4%' or el_to_domain_index like 'http://V4%' ) 

group by el_to_domain_index , el_to_path )

SELECT  CONCAT(' # – ',   GROUP_CONCAT(' – ' suboutput )) as output

FROM sq

​

;