SELECT COUNT( results.member_id ) AS numPlayers
FROM tournaments

LEFT JOIN results ON tournaments.id = results.tournament_id
WHERE (
venues.name LIKE '%voodoo%'
)
GROUP BY (
tournaments.id
)
ORDER BY tournaments.id ASC