SELECT
	IF(country_cod='ru','Россия',
	..............................
	IF(country_cod='lv','Латвия',
	IF(country_cod='ua','Украина',
		'Неизвестный язык'))...)),
	count(referer)
FROM log
WHERE login='305'
	AND date>'2001-05-06 00:00:00'
	AND date