Untitled query #68038

SQL

select 
el_to,
sum(el_to like "%hkm.%") as hkm,
sum(el_to like "%musketti.%") as musketti,
sum(el_to like "%museovirasto.%") as museovirasto,
sum(el_to like "%sls.%") as sls,
sum(el_to like "%doria.%") as doria,
sum(el_to like "%kouvolanmuseo.%") as kouvolanmuseo,
sum(el_to like "%keravan_museopalvelut.%") as keravan_museopalvelut,
sum(el_to like "%ekm.%") as ekm,
sum(el_to like "%muistaja_kerava.%") as muistaja_kerava,
sum(el_to like "%musketti_rautatie.%") as musketti_rautatie,
sum(el_to like "%vantaa.%") as vantaa,
sum(el_to like "%kansa_ah.%") as kansa_ah,
sum(el_to like "%musketti_kym.%") as musketti_kym,
sum(el_to like "%nurmes.%") as nurmes.knp

from externallinks 
where 
(el_index_60 like "https://fi.finna%" or el_index_60 like "http://fi.finna%")
and el_to not like "%hkm.%"
and el_to not like "%musketti.%"
and el_to not like "%museovirasto.%"
and el_to not like "%sls.%"
and el_to not like "%doria.%"
and el_to not like "%kouvolanmuseo.%"
and el_to not like "%keravan_museopalvelut.%"
group by el_to;
SQL

Checking query status...
