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


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...
