SELECT DISTINCT(country.country_id), country_name.short_name, country.event_id, country_name.iso2
FROM event_country as country
INNER JOIN country_codes AS country_name ON country.country_id = country_name.country_id
WHERE country.event_id in (85179,85142,85105,85086,85069,84968,84858,84814)