Left outer join + if statement

gistfile1.txt

select stuff.*, if(
  exchange_rate.rate is null,
  (select rate from exchange_rates order by month desc limit 1),
  exchange_rate.rate
)
from stuff
left outer join exchange_rate on exchange_rate.stuff_id = stuff.id;