SQL Queries to determine d.o brainstorming participation

gistfile1.txt

# 258 people in total participated.

SELECT DISTINCT u.name FROM users u
  INNER JOIN node n ON u.uid = n.uid
  INNER JOIN og_ancestry o ON n.nid = o.nid
WHERE
  group_nid = 312008 /* Drupal.org brainstorming */
UNION
SELECT DISTINCT u.name
FROM users u
  INNER JOIN comments c ON u.uid = c.uid
  INNER JOIN og_ancestry o ON c.nid = o.nid
WHERE
  group_nid = 312008 /* Drupal.org brainstorming */
UNION
SELECT DISTINCT u.name
FROM users u
  INNER JOIN votingapi_vote v ON v.uid = u.uid
  INNER JOIN og_ancestry o ON v.content_id = o.nid
WHERE
  group_nid = 312008 /* Drupal.org brainstorming */