#recordpool Weekly Analysis Report #12 (Weekly Contest #15)
Welcome to weekly analysis of #recordpool.The purpose of this analysis is to determine the weekly winner for #recordpool from 16/04/2018 - 22/04/2018. This statistics is extracted out base on the use of the tag #recordpool.
This stats is taken on 22/04/2018 6pm
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.
My TLDR explanation on #recordpool
Post a song that you like and share about your thoughts, and earn some Whaleshares and Hairshares!
All data are queried from SteemSQL until 15/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-12-weekly-contest-15
Overall Statistics
| Authors | Posts | Comments | Upvotes | Payouts |
|---|---|---|---|---|
| 156 | 1388 | 5723 | 34353 | 5741.2140 |
Weekly Statisctics
| Authors | Posts | Comments | Upvotes | Payouts |
|---|---|---|---|---|
| 40 | 179 | 553 | 6064 | 671.0710 |
Top Author
| Author | Posts | Upvotes | Comments | Payout |
|---|---|---|---|---|
| @warmcracklesound | 7 | 83 | 10 | 23.6020 |
| @inthenow | 6 | 230 | 20 | 7.6010 |
| @recordpool | 5 | 566 | 24 | 56.4970 |
| @asonintrigue | 5 | 143 | 5 | 13.8220 |
| @askeb | 5 | 121 | 3 | 17.8440 |
| @iamevilradio | 5 | 47 | 10 | 1.6390 |
| @rawselectmusic | 4 | 106 | 16 | 8.6360 |
| @calisay | 4 | 64 | 2 | 3.4260 |
| @wolfnworbeikood | 3 | 187 | 24 | 154.5710 |
| @danstatus | 3 | 182 | 4 | 1.1590 |
Top Post of the week
In terms of upvotes
In terms of comments
SQL Queries
Overall 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
depth = 0 AND
created > '2017/07/07' AND
created < '2018/04/23' AND
CONTAINS(json_metadata, 'recordpool')
Weekly 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
depth = 0 AND
created >= '2018/04/06' AND
created < '2018/04/23' AND
CONTAINS(json_metadata, 'recordpool')
Top Author by number of post
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
depth = 0 AND
created >= '2018/04/16' AND
created < '2018/04/23' AND
CONTAINS(json_metadata, 'recordpool')
GROUP BY
Author
ORDER BY
Posts 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
depth = 0 AND
created >= '2018/04/16' AND
created < '2018/04/23' AND
CONTAINS(json_metadata, 'recordpool')
ORDER BY
Upvotes desc
恭喜你！您的这篇文章入选 @justyy 今日 (2018-04-24) 榜单 【优秀被错过的文章】, 回复本条评论24小时内领赏，点赞本评论将支持 @dailychina 并增加将来您的奖赏。
Congratulations! This post has been selected by @justyy as today's (2018-04-24) 【Good Posts You May Miss】, Steem On! Reply to this message in 24 hours to get rewards. Upvote this comment to support the @dailychina and increase your future rewards! ^_^
You've been upvoted by TeamMalaysia community. Here are trending posts by other TeamMalaysia authors at http://steemit.com/trending/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
#recordpool love
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by superoo7 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.