select count(*) knt from `groups` g join members m on m.grp_id = g.grp_id where g.grp_id = ? and ( private <> 'Y' )
Use the link above to invite your friends to joing fairwayfiles. Creating groups and getting emails when your friends post scores is the best part of fairwayfiles!