Removed left joins from weird query.