select g.id,
       g.name,
       g.type,
       g.court,
       g.begins,
       g.ends,
       g.cost,
       g.max_people,
       count(c.client_id) as has_people,
       g.added,
       g.modified
  from games g, clients c
 where g.id = c.game_id
   and g.cost <= c.paid
   and g.begins > now()
 group by c.game_id