beneficiaries from DHF- begünstigte vom DHF by hive-coding

hive-169321 · @hive-coding · 2025-08-02T10:56:57+00:00

$1.65

beneficiaries from DHF- begünstigte vom DHF

## EN 
A few days ago, okay, almost two weeks ago, @hive-124221 (Dogmingo) wanted to know who received the most from the [DHF](https://developers.hive.io/services/dhf.html).

So who received HBD from hive.fund?
First, I searched for it in HiveQL in the TXTransfer table, but there were no transfers to be found there. So I looked to see which table might still contain this data and found the VOProposalPays table.

 https://img.leopedia.io/DQmV9MRwr9n7m2kpRyfvfNf1GcXdRiYPagKd9g3k6rZKUuq/grafik.png

The query is very simple: just the sum of payments grouped by recipient and sorted by total:

 ```MSSQL
SELECT 
    receiver, 
    SUM(payment) AS total_payment
FROM VOProposalPays
GROUP BY receiver
ORDER BY total_payment DESC;
 ``` 


  | Recipient            | Total payment        |
|----------------------|----------------------|
| steem.dao            | 170113750.956        |
| hbdstabilizer        | 107005695.165        |
| valueplan            | 3456746.872          |
| keychain             | 801688.376           |
| howo                 | 620679.469           |
| ecency               | 607306.734           |
| peak.open            | 588499.69            |
| splinterlands        | 415507.62            |
| vsc.network          | 400,586.474           |
| spkproposal          | 377,152.279           |
| disregardfiat        | 251,051.894           |
| hiveauth             | 235,492.477           |
| leofinance           | 231,166.698           |
| hivewatchers         | 225,880.205           |
| fund.dbuzz           | 212,693.899           |
| blocktrades          | 204,230.00            |
| hivechain.app        | 193,676.008           |
| peak.proposals       | 177,384.182           |
| hivesql              | 174,687.863           |
| hive.multisig        | 162,594.929           |
| lordbutterfly        | 155,977.295           |
| imwatsi              | 152,388.462           |
| v4vapp.dhf           | 138,762.314           |
| actifit.funds        | 126,744.878           |
| hdev.fund            | 105007.617           |
| engrave.cold         | 90000.104            |
| hashkings            | 70113.946            |
| netuoso              | 65911.883            |
| fullalt.dhf          | 61554.486            |
| good-karma           | 59544.478            |
| deathwing            | 50825.493            |
| martibis             | 34736.306            |
| blockanarchist1      | 34539.53             |
| mahdiyari            | 31726.991            |
| hivedebitfund        | 31452.552            |
| detlev               | 30516.368            |
| justineh             | 29910.70             |
| vimm.dhf             | 27202.856            |
| fridaybot            | 25456.746            |
| ilysarazom           | 24989.934            |
| inertia              | 23240.502            |
| sbdpotato            | 21132.95             |
| hivefest             | 18985.623            |
| hivecreators         | 17640.66             |
| steem-keychain       | 16619.32             |
| zyptoapp             | 15158.972            |
| amgr                 | 10999.824            |
| worldmappin          | 7946.274             |
| fundacoven           | 7149.413             |
| pettycash            | 6984.592             |
| podping              | 6615.90              |
| superhive            | 5998.383             |
| steemonboarding      | 5861.46              |
| latino.romano        | 4999.92              |
| themarkymark         | 4353.914             |
| hivesearcher         | 4056.451             |
| openseed             | 3956.20              |
| anyx                 | 3790.831             |
| steemchiller         | 3635.412             |
| brofund              | 2999.952             |
| hive.loans           | 1872.792             |
| spaminator           | 1214.096             |
| vimm                 | 1164.534             |
| haveyoubeenhere      | 1107.614             |
| dapplr               | 982,182              |
| esteemapp            | 969,674              |
| hive-woodpeckers     | 530,40               |
| fabien               | 466,962              |
| stemsocial-dev       | 329,472              |
| poshbot              | 269.36               |
| smooth               | 139,992              |
| emrebeyler           | 43,413               |
| steem-plus           | 18,729               |
| steemitworldmap      | 5,414                |


## Important
These are only the payments from hive.fund to the corresponding accounts. Regardless of what happens to the HBD and whether there were any repayments! steem.dao is the return proposal, if I'm not mistaken.


This is for the entire term, here is another query for 2025, i.e. ~7 months:


```MSSQL
SELECT 
    receiver, 
    SUM(payment) AS total_payment
FROM VOProposalPays
where year(timestamp)=2025
GROUP BY receiver
ORDER BY total_payment DESC;
```



| Recipient        | Total payment     |
|------------------|-------------------|
| steem.dao        | 46099840.871      |
| hbdstabilizer    | 2398502.912       |
| valueplan        | 617789.161        |
| vsc.network      | 183218.987        |
| keychain         | 127400.16         |
| hdev.fund        | 82810.104         |
| ecency           | 82153.604         |
| howo             | 71,958.504         |
| peak.open        | 67,429.552         |
| disregardfiat    | 48,051.033         |
| splinterlands    | 47,208.864         |
| hivedebitfund    | 31,618.812         |
| vimm.dhf         | 23992.00          |
| hivewatchers     | 20169.992         |
| zyptoapp         | 15158.972         |
| detlev           | 13926.765         |
| worldmappin      | 8084.399          |
| mahdiyari        | 5106.643          |
| actifit.funds    | 3219.888          |
| leofinance       | 1940.21           |
| hive-woodpeckers | 530.40            |
| hivesql          | 135.00            |

Translated with DeepL.com (free version)


## DE 
Vor paar Tagen, Ok sind schon fast 2 Wochen, wollte @hive-124221 (Dogmingo) gerne wissen, wer am meisten aus dem [DHF](https://developers.hive.io/services/dhf.html) erhalten hat.

Wer hat also HBD von hive.fund erhalten?
Zunächst habe ich danach in HiveQL in der TXTransfer Tabelle gesucht, aber dort waren keine Transfers zu finden. Daher habe ich geschaut, welche Tabelle diese Daten noch beinhalten könnte und habe die Tabelle VOProposalPays gefunden.

 https://img.leopedia.io/DQmV9MRwr9n7m2kpRyfvfNf1GcXdRiYPagKd9g3k6rZKUuq/grafik.png 

Die Abfrage ist damit sehr simpel, einfach die Summe der Zahlungen gruppiert nach Empfänger und sortiert nach der Summe:

 ```MSSQL
SELECT 
    receiver, 
    SUM(payment) AS total_payment
FROM VOProposalPays
GROUP BY receiver
ORDER BY total_payment DESC;
 ``` 


  | Empfänger            | Gesamtzahlung        |
|----------------------|----------------------|
| steem.dao            | 170113750,956        |
| hbdstabilizer        | 107005695,165        |
| valueplan            | 3456746,872          |
| keychain             | 801688,376           |
| howo                 | 620679,469           |
| ecency               | 607306,734           |
| peak.open            | 588499,69            |
| splinterlands        | 415507,62            |
| vsc.network          | 400586,474           |
| spkproposal          | 377152,279           |
| disregardfiat        | 251051,894           |
| hiveauth             | 235492,477           |
| leofinance           | 231166,698           |
| hivewatchers         | 225880,205           |
| fund.dbuzz           | 212693,899           |
| blocktrades          | 204230,00            |
| hivechain.app        | 193676,008           |
| peak.proposals       | 177384,182           |
| hivesql              | 174687,863           |
| hive.multisig        | 162594,929           |
| lordbutterfly        | 155977,295           |
| imwatsi              | 152388,462           |
| v4vapp.dhf           | 138762,314           |
| actifit.funds        | 126744,878           |
| hdev.fund            | 105007,617           |
| engrave.cold         | 90000,104            |
| hashkings            | 70113,946            |
| netuoso              | 65911,883            |
| fullalt.dhf          | 61554,486            |
| good-karma           | 59544,478            |
| deathwing            | 50825,493            |
| martibis             | 34736,306            |
| blockanarchist1      | 34539,53             |
| mahdiyari            | 31726,991            |
| hivedebitfund        | 31452,552            |
| detlev               | 30516,368            |
| justineh             | 29910,70             |
| vimm.dhf             | 27202,856            |
| fridaybot            | 25456,746            |
| ilysarazom           | 24989,934            |
| inertia              | 23240,502            |
| sbdpotato            | 21132,95             |
| hivefest             | 18985,623            |
| hivecreators         | 17640,66             |
| steem-keychain       | 16619,32             |
| zyptoapp             | 15158,972            |
| amgr                 | 10999,824            |
| worldmappin          | 7946,274             |
| fundacoven           | 7149,413             |
| pettycash            | 6984,592             |
| podping              | 6615,90              |
| superhive            | 5998,383             |
| steemonboarding      | 5861,46              |
| latino.romano        | 4999,92              |
| themarkymark         | 4353,914             |
| hivesearcher         | 4056,451             |
| openseed             | 3956,20              |
| anyx                 | 3790,831             |
| steemchiller         | 3635,412             |
| brofund              | 2999,952             |
| hive.loans           | 1872,792             |
| spaminator           | 1214,096             |
| vimm                 | 1164,534             |
| haveyoubeenhere      | 1107,614             |
| dapplr               | 982,182              |
| esteemapp            | 969,674              |
| hive-woodpeckers     | 530,40               |
| fabien               | 466,962              |
| stemsocial-dev       | 329,472              |
| poshbot              | 269,36               |
| smooth               | 139,992              |
| emrebeyler           | 43,413               |
| steem-plus           | 18,729               |
| steemitworldmap      | 5,414                |

## Wichtig
Dies sind nur die Zahlungen aus dem hive.fund an die entsprechenden Accounts. Unabhängig, was mit den HBD dann passiert und ob es ggf. auch Rückzahlungen gab! steem.dao ist das Return Proposal wenn ich mich nicht täusche.

Das ist über die gesamte Laufzeit, hier noch eine Abfrage für 2025, also ~7 Monate:

 ```MSSQL
SELECT 
    receiver, 
    SUM(payment) AS total_payment
FROM VOProposalPays
where year(timestamp)=2025
GROUP BY receiver
ORDER BY total_payment DESC;
 ```

| Empfänger        | Gesamtzahlung     |
|------------------|-------------------|
| steem.dao        | 46099840,871      |
| hbdstabilizer    | 2398502,912       |
| valueplan        | 617789,161        |
| vsc.network      | 183218,987        |
| keychain         | 127400,16         |
| hdev.fund        | 82810,104         |
| ecency           | 82153,604         |
| howo             | 71958,504         |
| peak.open        | 67429,552         |
| disregardfiat    | 48051,033         |
| splinterlands    | 47208,864         |
| hivedebitfund    | 31618,812         |
| vimm.dhf         | 23992,00          |
| hivewatchers     | 20169,992         |
| zyptoapp         | 15158,972         |
| detlev           | 13926,765         |
| worldmappin      | 8084,399          |
| mahdiyari        | 5106,643          |
| actifit.funds    | 3219,888          |
| leofinance       | 1940,21           |
| hive-woodpeckers | 530,40            |
| hivesql          | 135,00            |





Posted Using [INLEO](https://inleo.io/@hive-coding/beneficiaries-from-dhf-begnstigte-vom-dhf-pj)

👍 fw206, vikisecrets, dach-support, mein-senf-dazu, dibblers.dabs, condeas, reiseamateur, reward.app, siphon, ozelot47, grocko, hive-199275, woelfchen, xchng, davidlionfish, darth-azrael, bilginselcuk, trezzahn, upme, sevenoh-fiveoh, linuxbot, egistar, thanksforplaying, darth-cryptic, siphon.tribes, emrysjobber, golddeck, doomsdaychassis, patchwork, fikif, stem.alfa, retrodroid, hivegadgets, vscampbell, shinpurple, flxlove, sewzee, hivetycoon, m1sterjw, justinbennett, lolz.alive, kharma.scribbles, taco-pizza, mylibrary, ityp, randomblock1, oac, learn2code, holovision.stem, freegifts, hellene8, replicantua, logantron, jairv.r21, koussbar, wallets4sale, penned-bullshit, madame-cyntaia, ltcih, joeyarnoldvn, magic.byte, bbarelyseal, memess.byte

properties (23)vote details (63)

voter	rshares	pct
randomblock1	1,162,694,525	15%
darth-azrael	23,325,648,397	7%
darth-cryptic	3,937,879,921	7%
hellene8	720,122,638	15%
joeyarnoldvn	449,579,599	1.47%
grocko	96,445,747,733	100%
vikisecrets	931,368,729,542	33%
upme	9,389,983,756	15%
reiseamateur	195,497,717,113	50.2%
condeas	444,368,538,266	20%
siphon	116,922,850,157	50%
doomsdaychassis	2,983,297,470	15%
dach-support	892,005,143,121	100%
flxlove	1,831,394,668	30%
xchng	28,131,216,075	80%
ltcih	456,267,613	30%
ityp	1,197,756,414	30%
thanksforplaying	4,085,350,471	30%
fw206	1,356,734,611,413	16%
linuxbot	6,435,722,038	20%
oac	1,152,272,044	30%
wallets4sale	533,468,630	30%
retrodroid	2,226,904,778	7%
golddeck	3,357,757,165	30%
logantron	693,109,459	30%
kharma.scribbles	1,311,883,621	75%
ozelot47	105,682,716,150	100%
replicantua	704,097,502	16.5%
stem.alfa	2,366,254,651	50%
davidlionfish	25,921,608,612	100%
penned-bullshit	463,769,820	50%
woelfchen	67,042,740,737	16%
emrysjobber	3,504,758,357	25%
reward.app	150,680,786,881	30%
sevenoh-fiveoh	8,893,809,767	15%
mylibrary	1,216,109,786	30%
mein-senf-dazu	478,502,037,967	100%
egistar	5,341,369,533	20%
holovision.stem	872,552,387	50%
dibblers.dabs	449,552,009,250	100%
trezzahn	10,014,893,927	100%
siphon.tribes	3,669,165,560	100%
shinpurple	1,910,575,489	50%
fikif	2,648,928,413	30%
koussbar	561,110,621	30%
madame-cyntaia	462,935,435	18%
m1sterjw	1,628,123,541	100%
lolz.alive	1,430,166,485	30%
patchwork	2,809,231,919	50%
hive-199275	81,398,481,318	100%
taco-pizza	1,229,729,351	50%
bilginselcuk	13,213,454,164	83%
freegifts	787,726,432	100%
hivegadgets	2,215,230,121	50%
vscampbell	2,044,358,924	15%
hivetycoon	1,733,796,507	100%
justinbennett	1,457,593,240	15%
learn2code	1,062,963,490	50%
memess.byte	0	100%
bbarelyseal	0	100%
magic.byte	0	100%
jairv.r21	647,552,583	100%
sewzee	1,756,185,942	15%

`author`	hivebuzz
`permlink`	notify-1754379746
`category`	hive-169321
`json_metadata`	{"image":["https://hivebuzz.me/notify.t6.png"]}
`created`	2025-08-05 07:42:27
`last_update`	2025-08-05 07:42:27
`depth`	1
`children`	0
`last_payout`	1969-12-31 23:59:59
`cashout_time`	2025-08-12 07:42:27
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,484
`author_reputation`	370,752,520,390,273
`root_title`	"beneficiaries from DHF- begünstigte vom DHF"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	144,704,039
`net_rshares`	0