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 
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
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
#recordpool Weekly Analysis Report #9 (Weekly Contest #12) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-9-weekly-contest-12
Song of the Day - Gary Valenciano - Anak https://steemit.com//recordpool/@robin-ho/song-of-the-day-gary-valenciano-anak
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
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
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
Down The Blockchain. A New Steemy Steemit Theme Song. https://steemit.com//music/@soundwavesphoton/down-the-blockchain-a-new-steemy-steemit-theme-song 
(RecordPool) Song of the Day - Woman Like a Man https://steemit.com//recordpool/@lost108/recordpool-song-of-the-day-woman-like-a-man
Scuzzy's Digest #11 | Steemit Record Pool https://steemit.com//curate/@recordpool/scuzzy-s-digest-11-or-steemit-record-pool
Curadoria Msp-Music 19 à 28 de março - #ptmusic https://steemit.com//ptmusic/@thomashblum/curadoria-msp-music-19-a-28-de-marco-ptmusic 
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
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
#recordpool Weekly Analysis Report #9 (Weekly Contest #12) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-9-weekly-contest-12
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
Composer of the week #3 (Mozart) (SBD Share) https://steemit.com//classical-music/@classical-radio/composer-of-the-week-3-mozart-sbd-share 
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
Contests of Steemit - April 2018 Edition https://steemit.com//contest/@doctoryak/contests-of-steemit-april-2018-edition 
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 
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 
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
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
