domains with disallowed characters

SQL

WITH u AS (
SELECT page_title, el_to_domain_index
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 and el_to_domain_index REGEXP '.*([%&~@#;+=~"\'£\<\>\(\)#\$]+).*' collate 'utf8_general_ci' and  (el_to_domain_index like 'http%')  
UNION ALL
SELECT page_title, el_to_domain_index
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 and el_to_domain_index LIKE '%..%'  and  (el_to_domain_index like 'http%')  
)
SELECT CONCAT( '# ' , /*, el_to_domain_index , el_to_path , */ '  {{Bearbeiten|',u.page_title ,'|text=',u.page_title,'}}'  )as output , u.el_to_domain_index
FROM u
ORDER BY length(u.el_to_domain_index) desc
;/* &~‘@*(),!?_#$€£^;+=<> */

;
SQL

Checking query status...
