Welcome to weekly analysis of #recordpool.The purpose of this analysis is to determine the weekly winner for #recordpool from 02/04/2018 - 08/04/2018. This statistics is extracted out base on the use of the tag #recordpool.
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 winners will be done by @recordpool.
All data are queried from SteemSQL until 08/04/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)
For better reading experience, please use busy.org: https://busy.org/@superoo7/recordpool-weekly-analysis-report-10-weekly-contest-13
Overall Statistics
| Authors | Posts | Comments | Upvotes | Payouts |
|---|---|---|---|---|
| 149 | 1232 | 5199 | 28776 | 5193.4330 |
Weekly Statistics
| Authors | Posts | Comments | Upvotes | Payouts |
|---|---|---|---|---|
| 27 | 66 | 237 | 2635 | 306.0560 |
Top 10 Author of the week (in terms on number of post)
| Authors | Posts | Votes | Comments | Total_Payout |
|---|---|---|---|---|
| @warmcracklesound | 11 | 131 | 14 | 157.4650 |
| @inthenow | 7 | 233 | 11 | 2.0260 |
| @calisay | 7 | 65 | 9 | 2.8070 |
| @iamevilradio | 7 | 57 | 15 | 1.8430 |
| @rawselectmusic | 5 | 540 | 24 | 51.6470 |
| @mateonav53 | 5 | 379 | 12 | 1.3170 |
| @lost108 | 2 | 124 | 1 | 6.3760 |
| @robin-ho | 2 | 123 | 1 | 1.0190 |
| @soularecryptz | 2 | 8 | 5 | 0.0190 |
| @superoo7 | 1 | 221 | 7 | 7.6910 |
Top 10 Post of the week
in terms of upvotes
in terms of number of comments
SQL Queries
I will drop my SQL Queries here in case anyone wonder
This week statistics
SELECT
COUNT(DISTINCT author) AS Authors,
COUNT(*) AS Posts,
SUM(children) AS Comments,
SUM(net_votes) AS Upvotes,
SUM(pending_payout_value) + SUM(total_payout_value) AS Payouts
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'04/02/2018') AND
created< CONVERT(datetime,'04/09/2018') AND
depth = 0 AND
ISJSON(json_metadata) > 0 AND
CONTAINS(json_metadata, 'recordpool')
Top Author of the week
SELECT
'@' + author AS Authors,
COUNT(*) AS Posts,
SUM(net_votes) AS Votes,
SUM(children) AS Comments,
SUM(pending_payout_value) + SUM(total_payout_value) AS Total_Payout
FROM
COMMENTS (NOLOCK)
WHERE
dirty = 'False' AND
ISJSON(json_metadata) > 0 AND
CONTAINS(json_metadata, 'recordpool') AND
parent_author = '' and
created >= CONVERT(datetime,'04/02/2018') AND
created< CONVERT (datetime, '04/09/2018')
GROUP BY
Author
ORDER BY
Total_Payout DESC
Top Post of the week
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,'04/02/2018') AND
created< CONVERT(datetime,'04/09/2018') AND
depth = 0 AND
ISJSON(json_metadata) > 0 AND
CONTAINS(json_metadata, 'recordpool')
ORDER BY
Upvotes desc
[
)](https://steemit.com/@superoo7)
Hello @superoo7,
A few hints to improve your SteemSQL queries:
depth=0andparent_author = ''are redundant filters. You should use only one of them.depthcolumn is indexed andparent_authoris not. Therefore, you should removeparent_author = ''from your WHERE clause.It is useless to add
ISJSON(json_metadata) > 0when you useCONTAINS(json_metadata, ...). You're just slowing down your query (and others users).CONVERT(datetime,'04/02/2018')-> the use of CONVERT is useless.When using datetime, better to use the notation 'yyyy-mm-dd' (ex: '2018-04-02' ) to avoid problem with date format.
dirty = 'False'should NOT be used. The dirty column will be deprecated soon.Hey @arcange, thanks for stopping by and the suggestions. I will update my query in the next analysis.
Kudos to our Data Analyst Guru @Super007 !
Thanks man
#recordpool love
You've been upvoted by TeamMalaysia community. Do checkout other posts made by other TeamMalaysia authors at http://steemit.com/created/teammalaysia
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
WOO congrats to everyone here.
exchange follow votes steemit steem 😘😍