with sq as (select el_to_domain_index as ipadr, CONCAT(   '\n#*: – '   , 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('# – ',  ipadr, ' – ' , GROUP_CONCAT(' – ', suboutput )) as output

FROM sq

GROUP BY ipadr

ORDER BY count(*) desc, ipadr

;