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 '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 .
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
11 131 14 157.4650
7 233 11 2.0260
7 65 9 2.8070
7 57 15 1.8430
5 540 24 51.6470
5 379 12 1.3170
2 124 1 6.3760
2 123 1 1.0190
2 8 5 0.0190
1 221 7 7.6910
Top 10 Post of the week
in terms of upvotes
Title Author Upvotes Comments Payout
RAW SELECT RECORD REVIEW: El Michels Affair - Return To The 37th Chamber [funk/soul band covers of Wu-Tang classics] https://steemit.com//music/@rawselectmusic/raw-select-record-review-el-michels-affair-return-to-the-37th-chamber-funk-soul-band-covers-of-wu-tang-classics 401 6 45.1050
#recordpool Weekly Analysis Report #9 (Weekly Contest #12) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-9-weekly-contest-12 221 7 7.6910
Song of the Day - Gary Valenciano - Anak https://steemit.com//recordpool/@robin-ho/song-of-the-day-gary-valenciano-anak 116 1 0.6210
Song Of The Day: "Age Ain't Nothing But A Number" by Aaliyah - She Dated R. Kelly?? https://steemit.com//recordpool/@mateonav53/song-of-the-day-age-ain-t-nothing-but-a-number-by-aaliyah-she-dated-r-kelly 114 2 0.3760
Song Of The Day: Reminiscing on Linkin Park "Lying From You" https://steemit.com//recordpool/@mateonav53/steemit-recordpool-reminiscing-on-linkin-park-lying-from-you 113 1 0.3690
Song Of The Day: Classic Hip Hop About Splitting Some Weed With The Fam "I Got 5 On It" by Luniz https://steemit.com//recordpool/@mateonav53/steemit-recordpool-classic-hip-hop-about-splitting-some-weed-with-the-fam-i-got-5-on-it-by-luniz 113 4 0.3320
Down The Blockchain. A New Steemy Steemit Theme Song. https://steemit.com//music/@soundwavesphoton/down-the-blockchain-a-new-steemy-steemit-theme-song 111 93 16.4370
(RecordPool) Song of the Day - Woman Like a Man https://steemit.com//recordpool/@lost108/recordpool-song-of-the-day-woman-like-a-man 103 0 6.2650
Scuzzy's Digest #11 | Steemit Record Pool https://steemit.com//curate/@recordpool/scuzzy-s-digest-11-or-steemit-record-pool 91 2 5.0850
Curadoria Msp-Music 19 à 28 de março - #ptmusic https://steemit.com//ptmusic/@thomashblum/curadoria-msp-music-19-a-28-de-marco-ptmusic 85 4 4.9610
in terms of number of comments
Title Author Upvotes Comments Payout
Down The Blockchain. A New Steemy Steemit Theme Song. https://steemit.com//music/@soundwavesphoton/down-the-blockchain-a-new-steemy-steemit-theme-song 111 93 16.4370
BEST NEW MUSIC: Adryiano - You and Me and Her EP [deep house] https://steemit.com//music/@rawselectmusic/best-new-music-adryiano-you-and-me-and-her-ep-deep-house 17 12 0.2720
#recordpool Weekly Analysis Report #9 (Weekly Contest #12) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-9-weekly-contest-12 221 7 7.6910
RAW SELECT RECORD REVIEW: El Michels Affair - Return To The 37th Chamber [funk/soul band covers of Wu-Tang classics] https://steemit.com//music/@rawselectmusic/raw-select-record-review-el-michels-affair-return-to-the-37th-chamber-funk-soul-band-covers-of-wu-tang-classics 401 6 45.1050
Composer of the week #3 (Mozart) (SBD Share) https://steemit.com//classical-music/@classical-radio/composer-of-the-week-3-mozart-sbd-share 21 6 0.4050
Audio "Guy" Story time! The ultimate secret combo of tunes to make Squares dance! https://steemit.com//recordpool/@warmcracklesound/audio-guy-story-time-the-ultimate-secret-combo-of-tunes-to-make-squares-dance 17 6 0.3220
Contests of Steemit - April 2018 Edition https://steemit.com//contest/@doctoryak/contests-of-steemit-april-2018-edition 58 5 28.4540
Song of the day - Claude Debussy (1862 - 1918) - Clair de Lune https://steemit.com//recordpool/@guifaquetti/song-of-the-day-claude-debussy-1862-1918-clair-de-lune 55 5 0.8090
SONG OF THE DAY// RECORDPOOL//RAY CHARLES//HIT THE ROAD JACK https://steemit.com//recordpool/@josevallera/song-of-the-day-recordpool-ray-charles-hit-the-road-jack 42 5 0.1190
Song of the Day - You Are Not Fixed by FBK https://steemit.com//recordpool/@iamevilradio/song-of-the-day-you-are-not-fixed-by-fbk 8 5 0.3140
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 séc