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   el_to_domain_index not in ( 'http://org.apache.httpd.' ,'https://org.apache.httpd.' 
                                 , 'https://com.http-statuscode.'
                                 , 'https://com.e-monsite.httpcyclomotosloire.'
                                 , 'https://kehttps.co.theeastafrican.www.'
                                 , 'http://com.buyhttp.www.');
SQL

Checking query status...
