по положительной карме
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