..snip snip
>>ORDER BY fld_team_score DESC;>
It's not specifically about youre error but this order by is surelyredundant and just slows down the query.
Matthew