You are viewing a single comment's thread from:

RE: Using hiveSQL to find content

in STEMGeeks • 4 years ago 
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 voters
4 years ago in STEMGeeks by
$0.00
    1 vote
    Reply 2
    Sort:  
  • Trending
    • [-]
     4 years ago  

    I like it, cheers!

    [-]
     4 years ago  

    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.

    $0.00
      Reply