That got me quite a ways towards my target:
select
t.user_id,
ucf.value,
count(*)
from
topics t
join user_custom_fields ucf on t.id = cast(ucf.value as int)
where ucf.name = 'votes'
group by ucf.value, t.user_id
order by t.user_id, count(*) desc
That returns:
The two things I’m trying to get are total votes someone got and the topic that has the most votes for each person. You can see mmontecalvo has 2 topics showing. I’m fairly certain I need to use row_number() to get just the highest post but I don’t know how.
@codinghorror These may be similar to a default badge but none of the defaults are built off topics getting votes.