MIT Bitcoin Expo MIT Bitcoin Expo 2021 .

[-] Tags
vote_value vote_count
academic1
agenda1
committee1
gold1
good1
hastext1
hastitle1
image1
like1
media1
notext1
pubkey1
puzzle1
silver1
speaker1
sponsor1
track11
track21


SELECT vote_value, vote_count FROM ( SELECT vote_value, COUNT(vote_value) AS vote_count FROM vote LEFT JOIN vote_value ON (vote.vote_value = vote_value.vote) WHERE IFNULL(vote_value.value, 0) >= 0 AND file_hash IN (SELECT file_hash FROM item) GROUP BY vote.vote_value, file_hash ) WHERE vote_count >= 1 GROUP BY vote_value ORDER BY vote_count

^^