golos_flags_ratings_queries

-- топ суммарной силы флагов от одного аккаунта другому
SELECT
  voter,
  author,
  sum((vesting_shares * weight / 10000)) as weighted_vesting_flags
FROM golos_votes
  JOIN golos_accounts ON (name = voter)
WHERE timestamp > '2016-12-01'
      AND weight < 0
GROUP BY author, voter
order by weighted_vesting_flags asc

-- топ суммарной силы полученных флагов за декабрь
SELECT
  author,
  sum((vesting_shares * weight / 10000)) as weighted_vesting_flags
FROM golos_votes
  JOIN golos_accounts ON (name = voter)
WHERE timestamp > '2016-12-01'
      AND weight < 0
GROUP BY author
order by weighted_vesting_flags asc