по положительной карме

SELECT SUM(karmaGood), lp.ID_CHOICE
FROM log_polls lp
  JOIN members m ON (m.ID_MEMBER = lp.ID_MEMBER)
WHERE lp.ID_POLL = ?
GROUP BY lp.ID_CHOICE

по дате регистрации

SELECT SUM((UNIX_TIMESTAMP() - dateRegistered)/60/60/24), lp.ID_CHOICE
FROM log_polls lp
  JOIN members m ON (m.ID_MEMBER = lp.ID_MEMBER)
WHERE lp.ID_POLL = ?
GROUP BY lp.ID_CHOICE;

по количеству постов

SELECT SUM(posts), lp.ID_CHOICE
FROM log_polls lp
  JOIN members m ON (m.ID_MEMBER = lp.ID_MEMBER)
WHERE lp.ID_POLL = ?
GROUP BY lp.ID_CHOICE;

по уникальным айпишникам

SELECT COUNT(DISTINCT(memberIP)), lp.ID_CHOICE
FROM log_polls lp
  JOIN members m ON (m.ID_MEMBER = lp.ID_MEMBER)
WHERE lp.ID_POLL = ?
GROUP BY lp.ID_CHOICE;

Обновлено Sun Apr 20 11:58:28 2014 +0400