Viewing a response to: @holger80/rewarding-paid-out-posts-without-using-python
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 ```
author | inertia |
---|---|
permlink | re-holger80-rewarding-paid-out-posts-without-using-python-20181105t201851418z |
category | steemdev |
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"} |
created | 2018-11-05 20:18:51 |
last_update | 2018-11-06 15:16:18 |
depth | 1 |
children | 1 |
last_payout | 2018-11-12 20:18:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.131 HBD |
curator_payout_value | 0.042 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 3,431 |
author_reputation | 346,568,901,399,561 |
root_title | "Rewarding paid-out posts without using python" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 74,744,054 |
net_rshares | 159,886,067,712 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
holger80 | 0 | 154,214,763,118 | 82% | ||
condeas | 0 | 5,671,304,594 | 33% |
The fullnodeupdate entries are only for testing the scripts.
author | holger80 |
---|---|
permlink | re-inertia-re-holger80-rewarding-paid-out-posts-without-using-python-20181105t210008811z |
category | steemdev |
json_metadata | {"tags":["steemdev"],"app":"steemit/0.1"} |
created | 2018-11-05 21:00:12 |
last_update | 2018-11-05 21:00:12 |
depth | 2 |
children | 0 |
last_payout | 2018-11-12 21:00:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 60 |
author_reputation | 358,857,509,568,825 |
root_title | "Rewarding paid-out posts without using python" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 74,745,840 |
net_rshares | 0 |