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 'utf8mb3_general_ci'/*'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,page_title
;/* &~‘@*(),!?_#$€£^;+=<> */
SQL

Checking query status...
