COUNT question

--00163630ff2fca06b90492e0cfe2
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I've the following query

SELECT COUNT(players_id) AS players_count
FROM players
WHERE teams_id > 0
GROUP BY teams_id
ORDER BY players_count DESC

However, I've another field called original_teams_id and want to include the
COUNT with players_count, when original_teams_id = teams_id

Cheers
Neil

--00163630ff2fca06b90492e0cfe2--