enwiki archive.is count

SQL

USE enwiki_p;
SELECT l , count(el_to) as anz
FROM (
SELECT  el_to, substring(el_to,16,2) as l
FROM externallinks as eur 
   INNER JOIN page as pr on eur.el_from=pr.page_id
WHERE pr.page_namespace=0 and el_to like 'http://archive.__/%'
union all 
SELECT  el_to, substring(el_to,17,2) as l
FROM externallinks as eur 
   INNER JOIN page as pr on eur.el_from=pr.page_id
WHERE pr.page_namespace=0 and el_to like 'https://archive.__/%'
union all 
SELECT  el_to, 'today' as l
FROM externallinks as eur 
   INNER JOIN page as pr on eur.el_from=pr.page_id
WHERE pr.page_namespace=0 and el_to like 'http://archive.today/%'
union all 
SELECT  el_to, 'today' as l
FROM externallinks as eur 
   INNER JOIN page as pr on eur.el_from=pr.page_id
  WHERE pr.page_namespace=0 and el_to like 'https://archive.today/%' 
) AS el
GROUP BY l
SQL

Checking query status...
