Welcome to weekly analysis of #recordpool.The purpose of this analysis is to determine the weekly winner for #recordpool from 19/03/2018 - 25/03/2018.
What is recordpool? Checkout @djlethalskillz's post "Weekly Roudup Contest" at "'Steemit Record Pool' New Community Contest Update! Curate Music & Win Weekly Whaleshares & Hairshares!"
The announcement of the winner will be done by @recordpool.
All data are queried from SteemSQL until 18/03/2018. For a better reading experience, I would suggest using busy.org .
There might be a slight different for the payout since it is the sum of paid payout and pending payout (pending payout fluctuates with the price of sbd/steem and also affected by beneficiaries percentage)
Overall Statistics
| Author | Posts | Upvotes | Comments | Payout |
|---|---|---|---|---|
| 112 | 1023 | 21005 | 3957 | 3701.6640 |
Weekly Statistics (19/03/2018 - 25/03/2018)
| Author | Posts | Upvotes | Comments | Payout |
|---|---|---|---|---|
| 24 | 61 | 1445 | 129 | 160.8430 |
Weekly Top 10 authors (in terms of number of posts)
| Author | Posts | Upvotes | Comments | Payout |
|---|---|---|---|---|
| @calisay | 8 | 54 | 9 | 6.2460 |
| @mateonav53 | 7 | 365 | 10 | 6.9360 |
| @inthenow | 7 | 190 | 9 | 2.8300 |
| @danstatus | 5 | 45 | 9 | 64.0420 |
| @fourfourfun | 4 | 75 | 11 | 6.8240 |
| @iamevilradio | 4 | 31 | 13 | 1.5410 |
| @asonintrigue | 3 | 53 | 5 | 1.9880 |
| @rawselectmusic | 3 | 52 | 11 | 9.2040 |
| @bboyady | 2 | 125 | 9 | 4.4840 |
| @grayarty | 2 | 61 | 14 | 4.9580 |
Weekly Top 10 posts
In terms of upvotes
In terms of comments
SQL Queries
In case anyone interested in the SQL Queries I used.
Weekly Stats
SELECT
COUNT(DISTINCT author) as Author,
COUNT(*) as Posts,
SUM(net_votes) as Upvotes,
SUM(children) as Comments,
SUM(pending_payout_value) + SUM(total_payout_value) as Payout
FROM
Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'03/19/2018') AND
created< CONVERT(datetime,'03/26/2018') AND
depth = 0 AND
ISJSON(json_metadata) > 0 AND
'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
Top Author
SELECT
'@' + author AS Author,
COUNT(*) as Posts,
SUM(net_votes) as Upvotes,
SUM(children) as Comments,
SUM(pending_payout_value) + SUM(total_payout_value) as Payout
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'03/19/2018') AND
created< CONVERT(datetime,'03/26/2018') AND
depth = 0 AND
ISJSON(json_metadata) > 0 AND
'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
GROUP BY
Author
ORDER BY
Posts desc
Top Post
SELECT
title + ' https://steemit.com/' + url AS Title,
'@' + author AS Author,
net_votes as Upvotes,
children as Comments,
pending_payout_value + total_payout_value as Payout
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'03/19/2018') AND
created< CONVERT(datetime,'03/26/2018') AND
depth = 0 AND
ISJSON(json_metadata) > 0 AND
'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
ORDER BY
Upvotes desc
I took a break last week. Coming back strong this week.
#recordpool love
This post has been curated by TeamMalaysia Community :-
To support the growth of TeamMalaysia Follow our upvotes by using steemauto.com and follow trail of @myach
Vote TeamMalaysia witness bitrocker2020 using this link vote for witness
Much Respect @superoo7 for your continuous support to #recordpool
thank you for the data bro. you did a lot of great job
much appreciate
Sure man no worries
cheers