SELECTJson_value(voters.voters, '$.voter') AS voter,
Json_value(voters.voters, '$.time') AStime,
Json_value(voters.voters, '$.rshares') AS rshares
FROM (SELECT votes.[value] AS voters,
c.author,
c.permlink
FROM comments c
CROSS apply Openjson(c.active_votes) AS votes
WHERE c.author ='themarkymark'AND c.permlink ='315-pairs-of-socks-have-a-marketcap-of-usd28-million-dollars') AS voters
Congrats, you were upvoted from this account because you were in Top 25 engagers yesterday on STEMGeeks . You made a total of 3 comments and talked to 3 different authors . Your rank is 5 . For more details about this project please read here - link to announcement post You can also delegate and get weekly payouts.
SELECT Json_value(voters.voters, '$.voter') AS voter, Json_value(voters.voters, '$.time') AS time, Json_value(voters.voters, '$.rshares') AS rshares FROM (SELECT votes.[value] AS voters, c.author, c.permlink FROM comments c CROSS apply Openjson(c.active_votes) AS votes WHERE c.author = 'themarkymark' AND c.permlink = '315-pairs-of-socks-have-a-marketcap-of-usd28-million-dollars') AS votersI like it, cheers!
Congrats, you were upvoted from this account because you were in Top 25 engagers yesterday on STEMGeeks .
You made a total of 3 comments and talked to 3 different authors .
Your rank is 5 .
For more details about this project please read here - link to announcement post
You can also delegate and get weekly payouts.