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: @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
| Title | Author | Upvotes | Comments | Payout |
|---|---|---|---|---|
| Blockchain Music: 'RAP CRYPTO' 420 Remix By DJ Lethal Skillz | New Release https://steemit.com//dsound/@djlethalskillz/20180419t234943376z-blockchain-music-rap-crypto-2020-remix-by-dj-lethal-skillz--new-release | @djlethalskillz | 204 | 16 | 84.2430 |
| Song of the day - Mazeppa by Franz Liszt (1811 - 1886). https://steemit.com//recordpool/@guifaquetti/song-of-the-day-mazeppa-by-franz-liszt-1811-1886 | @guifaquetti | 194 | 5 | 3.2490 |
| Vibrations [#1] | Share Which Song Inspired You Today! | Best Comments Are Featured On the Next Episode! https://steemit.com//music/@recordpool/vibrations-1-or-share-which-song-inspired-you-today-or-best-comments-are-featured-on-the-next-episode | @recordpool | 180 | 9 | 24.4230 |
| Steemit Music Review [#7] | Curate Steemit Music Reviews & Win Weekly Rewards! https://steemit.com//contest/@recordpool/steemit-music-review-7-or-curate-steemit-music-reviews-and-win-weekly-rewards | @recordpool | 136 | 8 | 7.4220 |
| steem music challenge week 2- Bourree https://steemit.com//steem-music/@zhusatriani/steem-music-challenge-week-2-bourree | @zhusatriani | 123 | 7 | 4.2920 |
| Song of the Day - Golliwogg's Cakewalk https://steemit.com//classical-music/@grayarty/song-of-the-day-golliwogg-s-cakewalk | @grayarty | 122 | 4 | 7.0860 |
| #recordpool Weekly Analysis Report #11 (Weekly Contest #14) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-11-weekly-contest-14 | @superoo7 | 112 | 2 | 33.0080 |
| The @Musicvoter Challenge! - Week 8 - This Week's Initiative - Reward An Awesome Comment! https://steemit.com//helpie/@helpie/the-musicvoter-challenge-week-8-this-week-s-initiative-reward-an-awesome-comment | @helpie | 101 | 2 | 3.6180 |
| Song Of The Day: Boogie Down Productions - My Philosophy https://steemit.com//songoftheday/@danstatus/song-of-the-day-boogie-down-productions-my-philosophy | @danstatus | 97 | 2 | 0.5710 |
| Record Pool: Your Invitation to Become A Music Curator & Earn Weekly Rewards https://steemit.com//music/@recordpool/record-pool-your-invitation-to-become-a-music-curator-and-earn-weekly-rewards | @recordpool | 96 | 1 | 10.8280 |
In terms of comments
| Title | Author | Upvotes | Comments | Payout |
|---|---|---|---|---|
| Blockchain Music: 'RAP CRYPTO' 420 Remix By DJ Lethal Skillz | New Release https://steemit.com//dsound/@djlethalskillz/20180419t234943376z-blockchain-music-rap-crypto-2020-remix-by-dj-lethal-skillz--new-release | @djlethalskillz | 204 | 16 | 84.2430 |
| Song Of The Day: A Wintery, Acoustic Gem by Ray LaMontagne and Contemplating Life Changes https://steemit.com//recordpool/@mateonav53/song-of-the-day-a-wintery-acoustic-gem-by-ray-lamontagne-and-contemplating-life-changes | @mateonav53 | 23 | 14 | 0.5270 |
| Second Womb ~ Luck featuring Marty & Berlin...! /// Live from the Cave Volume 009 https://steemit.com//dsound/@wolfnworbeikood/20180420t233606912z-second-womb--luck-featuring-marty--berlin---live-from-the-cave-volume-009 | @wolfnworbeikood | 70 | 11 | 74.9730 |
| Record Pool // Song Of The Day - Tuhan Tak Perlu Dibela by Hafiz Della MC & KunoKini feat Indra Lesmana & Archipelago Choir https://steemit.com//recordpool/@vandigital/record-pool-song-of-the-day-tuhan-tak-perlu-dibela-by-hafiz-della-mc-and-kunokini-feat-indra-lesmana-and-archipelago-choir | @vandigital | 30 | 11 | 0.6260 |
| How To Join The MusicVoter Curation Trail And What Settings To Use https://steemit.com//musicvoter/@musicvoter/how-to-join-the-musicvoter-curation-trail-and-what-settings-to-use | @musicvoter | 75 | 10 | 1.6140 |
| Vibrations [#1] | Share Which Song Inspired You Today! | Best Comments Are Featured On the Next Episode! https://steemit.com//music/@recordpool/vibrations-1-or-share-which-song-inspired-you-today-or-best-comments-are-featured-on-the-next-episode | @recordpool | 180 | 9 | 24.4230 |
| Steemit Music Review [#7] | Curate Steemit Music Reviews & Win Weekly Rewards! https://steemit.com//contest/@recordpool/steemit-music-review-7-or-curate-steemit-music-reviews-and-win-weekly-rewards | @recordpool | 136 | 8 | 7.4220 |
| Song Of The Day: 3 Great Tracks I Just Discovered (DJ Koze/Pig & Dan/Mark Farina) https://steemit.com//recordpool/@mateonav53/song-of-the-day-3-great-tracks-i-just-discovered-dj-koze-pig-and-dan-mark-farina | @mateonav53 | 91 | 8 | 4.4090 |
| Father Earth ~ Scatter B {Steemit exclusive unreleased Instrumental} https://steemit.com//dsound/@wolfnworbeikood/20180421t203307338z-father-earth--scatter-b-steemit-exclusive-unreleased-instrumental | @wolfnworbeikood | 61 | 8 | 50.7970 |
| Steemit Music Review 7 - Drunk Jibberish by @fresheiremusic and @scribblingwilly! #musicreview https://steemit.com//musicreview/@kenentertainment/steemit-music-review-7-drunk-jibberish-by-fresheiremusic-and-scribblingwilly-musicreview | @kenentertainment | 8 | 8 | 0.1030 |
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
