You are viewing a single comment's thread from:

RE: Snaps Container // 1743183360

in Snaps • 28 days ago

I'll have to break into 2 snaps here to go:

select sum(case when [amount_symbol] = 'HIVE' THEN [amount] ELSE 0 END) AS HiveTotal,
sum(case when [amount_symbol] = 'HBD' THEN [amount] ELSE 0 END) AS HBDTotal
FROM [TxTransfers]
WHERE [from] = 'commentrewarder'

28 days ago in Snaps by
100%
    -100%

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      0.00 FOODIE
        1 vote
        Reply 3
        Sort:  
      • Trending
        • [-]
         28 days ago (edited)

        AND [to] = 'hive_user'
        AND [timestamp] >= DATEADD(day, -30, GETDATE())
        and [memo] like '%%@peak.snaps%'

        100%
          -100%

            Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

            • Disagreement on rewards
            • Fraud or plagiarism
            • Hate speech or trolling
            • Miscategorized content or spam

            Submit
            0.00 FOODIE
              1 vote
              Reply
              [-]
               28 days ago 

              Thanks mate!

              image.png

              100%
                -100%

                  Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                  • Disagreement on rewards
                  • Fraud or plagiarism
                  • Hate speech or trolling
                  • Miscategorized content or spam

                  Submit
                  0.00 FOODIE
                    2 votes
                    Reply
                    [-]
                     28 days ago 

                    No problem! It's much easier to track the performance of your snaps now

                    100%
                      -100%

                        Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                        • Disagreement on rewards
                        • Fraud or plagiarism
                        • Hate speech or trolling
                        • Miscategorized content or spam

                        Submit
                        0.00 FOODIE
                          Reply