WITH p as (

  SELECT page.page_id, page.page_title 

  FROM page 

  WHERE page.page_namespace = 0

) 

SELECT DISTINCT CONCAT( '# ' , externallinks.el_to_domain_index 

              , ' – {{Bearbeiten|',p.page_title ,'|text=',p.page_title,'}} – <nowiki>'  

              ,  externallinks.el_to_path ,' </nowiki>' )as output 

FROM  externallinks INNER JOIN p

  ON p.page_id = externallinks.el_from

WHERE externallinks.el_to_domain_index like 'http://V4.%'

ORDER BY 1;