domain with http in domainname

SQL

SELECT CONCAT(': {{Bearbeiten|',page_title ,'|text=',page_title,'}}  ___  ') as output, el_to_domain_index,
       CONCAT(REGEXP_REPLACE(el_to_domain_index,
                             '^(.*?://)(?:([^.]+)\\.)([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)$',
                             '\\1\\9\\8\\7\\6\\5\\4\\3\\2'),
              el_to_path) AS url
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0  and  el_to_domain_index LIKE '%_http%' 
and not  el_to_domain_index like 'http://org.apache.httpd.' 
and not  el_to_domain_index like 'https://org.apache.httpd.'
and not  el_to_domain_index like 'https://http-statuscode.com.';
SQL

Checking query status...
