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
