aleksyglvnw

select p.*
from prices p,
(select currency_id, max(relevant_from) max_relevant_from
  from price 
  where relevant_from <= NOW()
   group by currency_id) p2
where p.currency_id = p2.currency_id and p.relevant_from = p2.max_relevant_from