Converting subselects to joins

flamingcow.dilian.org