Someone
public sql v1 · immutableSELECT COUNT( results.member_id ) AS numPlayersFROM tournamentsLEFT JOIN results ON tournaments.id = results.tournament_idWHERE (venues.name LIKE '%voodoo%')GROUP BY (tournaments.id)ORDER BY tournaments.id ASC SELECT COUNT( results.member_id ) AS numPlayersFROM tournamentsLEFT JOIN results ON tournaments.id = results.tournament_idWHERE (venues.name LIKE '%voodoo%')GROUP BY (tournaments.id)ORDER BY tournaments.id ASC