create account

RE: Rewarding paid-out posts without using python by inertia

View this thread on: hive.blogpeakd.comecency.com

Viewing a response to: @holger80/rewarding-paid-out-posts-without-using-python

· @inertia · (edited)
$0.17
Current usage:

| Rewarded | Rep | Reward Payout | Reward Initiated By | URL
|-|-|-|-|-|
| 2018-11-03 22:29:15 UTC | 28 | 0.157 | beembot | [Full API Node Update - 25/10/2018](https://steemit.com/@fullnodeupdate/full-api-node-update---25102018) |
| 2018-11-03 23:20:24 UTC | 71 | 2.322 | inertia | [Jesus Is Cheering For Me In The Stands](https://steemit.com/@arrowj/jesus-is-cheering-for-me-in-the-stands-zg1hbmlh-aknh4) |
| 2018-11-03 23:38:21 UTC | 71 | 2.248 | inertia | [Roger & Snorre - The Spinning Man!](https://steemit.com/@fyrstikken/roger-and-snorre-the-spinning-man) |
| 2018-11-04 00:43:30 UTC | 44 | 0.022 | gerdtrudroepke | [Roepkereport der Fünfte, September 2018](https://steemit.com/@gerdtrudroepke/roepkereport-der-fuenfte-september-2018) |
| 2018-11-04 04:30:12 UTC | 71 | 2.13 | inertia | [Hi, I'm the Wandering Voluntaryist Chris Greyson](https://steemit.com/@wanderingagorist/hi-i-m-the-wandering-voluntaryist-chris-greyson) |
| 2018-11-04 05:04:12 UTC | 71 | 2.1 | inertia | [2003.Game - A Gaming Documentary Series](https://steemit.com/@free999enigma/2003-game-a-gaming-documentary-series) |
| 2018-11-04 05:57:06 UTC | 71 | 2.079 | inertia | [2004.Game - A Gaming Documentary Series](https://steemit.com/@free999enigma/2004-game-a-gaming-documentary-series) |
| 2018-11-04 06:12:36 UTC | 71 | 2.044 | inertia | [Bitcoin Gold Opening Altcoin Buy Opportunities](https://steemit.com/@cryptovestor/bitcoin-gold-opening-altcoin-buy-opportunities) |
| 2018-11-04 14:27:09 UTC | 51 | 0.177 | condeas | [GPU-Z erkennt gefälschte Grafikkarten](https://steemit.com/@sempervideo/gpu-z-erkennt-gefaelschte-grafikkarten) |
| 2018-11-04 22:57:12 UTC | 38 | 0.0 | rewarding | [Full API Node Update - 27/10/2018](https://steemit.com/@fullnodeupdate/full-api-node-update---27102018) |
| 2018-11-05 01:29:48 UTC | 38 | 2.093 | rewarding | [I explain to you step by step how I did the portrait](https://steemit.com/@miyata1987/29e6wa-i-explain-to-you-step-by-step-how-i-did-the-portrait) |
| 2018-11-05 02:46:54 UTC | 38 | 0.027 | rewarding | [Steem dollar policy update and warning to converters](https://steemit.com/@smooth.witness/steem-dollar-policy-update-and-warning-to-converters) |
| 2018-11-05 09:15:54 UTC | 38 | 0.0 | rewarding | [Full API Node Update - 23/10/2018](https://steemit.com/@fullnodeupdate/full-api-node-update---23102018) |
| 2018-11-05 15:39:24 UTC | 38 | 0.025 | rewarding | [Why you should let your son play with dolls / Por qué deberías dejar jugar a tu hijo con muñecas](https://steemit.com/@gabbygolden/why-you-should-let-you-son-play-with-dolls) |

This can be built using a Hivemind Postgres query:

```sql
SELECT "hive_posts".* 
FROM   "hive_posts" 
       inner join "hive_posts" "parents_hive_posts" 
               ON "parents_hive_posts"."id" = "hive_posts"."parent_id" 
       inner join "hive_posts_cache" 
               ON "hive_posts_cache"."post_id" = "hive_posts"."id" 
WHERE  "hive_posts"."depth" = 1 
       AND ( "hive_posts"."parent_id" IS NOT NULL ) 
       AND "hive_posts"."id" IN (SELECT "hive_posts_cache"."post_id" 
                                 FROM   "hive_posts_cache" 
                                 WHERE  ( json :: json ->> 'app' LIKE 'beem/%' ) 
                                ) 
       AND ( title = Concat('rewarding ', parents_hive_posts. author) ) 
       AND ( hive_posts.created_at > '2018-10-29 19:17:00.965472' ) 
ORDER  BY "hive_posts"."id" ASC
```
👍  ,
properties (23)
authorinertia
permlinkre-holger80-rewarding-paid-out-posts-without-using-python-20181105t201851418z
categorysteemdev
json_metadata{"tags":["steemdev"],"links":["https://steemit.com/@fullnodeupdate/full-api-node-update---25102018","https://steemit.com/@arrowj/jesus-is-cheering-for-me-in-the-stands-zg1hbmlh-aknh4","https://steemit.com/@fyrstikken/roger-and-snorre-the-spinning-man","https://steemit.com/@gerdtrudroepke/roepkereport-der-fuenfte-september-2018","https://steemit.com/@wanderingagorist/hi-i-m-the-wandering-voluntaryist-chris-greyson","https://steemit.com/@free999enigma/2003-game-a-gaming-documentary-series","https://steemit.com/@free999enigma/2004-game-a-gaming-documentary-series","https://steemit.com/@cryptovestor/bitcoin-gold-opening-altcoin-buy-opportunities","https://steemit.com/@sempervideo/gpu-z-erkennt-gefaelschte-grafikkarten","https://steemit.com/@fullnodeupdate/full-api-node-update---27102018","https://steemit.com/@miyata1987/29e6wa-i-explain-to-you-step-by-step-how-i-did-the-portrait","https://steemit.com/@smooth.witness/steem-dollar-policy-update-and-warning-to-converters","https://steemit.com/@fullnodeupdate/full-api-node-update---23102018","https://steemit.com/@gabbygolden/why-you-should-let-you-son-play-with-dolls"],"app":"steemit/0.1"}
created2018-11-05 20:18:51
last_update2018-11-06 15:16:18
depth1
children1
last_payout2018-11-12 20:18:51
cashout_time1969-12-31 23:59:59
total_payout_value0.131 HBD
curator_payout_value0.042 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length3,431
author_reputation346,568,901,399,561
root_title"Rewarding paid-out posts without using python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id74,744,054
net_rshares159,886,067,712
author_curate_reward""
vote details (2)
@holger80 ·
The fullnodeupdate entries are only for testing the scripts.
properties (22)
authorholger80
permlinkre-inertia-re-holger80-rewarding-paid-out-posts-without-using-python-20181105t210008811z
categorysteemdev
json_metadata{"tags":["steemdev"],"app":"steemit/0.1"}
created2018-11-05 21:00:12
last_update2018-11-05 21:00:12
depth2
children0
last_payout2018-11-12 21:00:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length60
author_reputation358,857,509,568,825
root_title"Rewarding paid-out posts without using python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id74,745,840
net_rshares0