Welcome to weekly analysis of #recordpool.The purpose of this analysis is to determine the weekly winner for #recordpool from 26/03/2018 - 01/04/2018.

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 01/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/recordpool/@superoo7/recordpool-weekly-analysis-report-9-weekly-contest-12

Overall Statisctics

Authors	Posts	Comments	Upvotes	Payouts
144	1166	4934	26111	4922.0010

Weekly Statistics (26/03/2018 - 01/04/2018)

Authors	Posts	Comments	Upvotes	Payouts
24	69	218	1965	144.3740

Weekly Top 10 authors (in terms of number of posts)(in terms of number of posts)

Authors	Posts	Votes	Comments	Total_Payout
@warmcracklesound	10	184	10	2.7310
@inthenow	7	183	7	2.5900
@iamevilradio	7	87	8	2.9960
@calisay	7	56	5	8.4950
@rawselectmusic	6	44	12	1.4160
@asonintrigue	5	252	30	7.0730
@bboyady	4	251	5	10.1410
@mateonav53	4	150	14	1.0690
@recordpool	2	65	27	12.9860
@danstatus	2	20	2	0.0880

Weekly Top 10 posts

in terms of upvotes

Title	Author	Upvotes	Comments	Payout
Steemit Recordpool: Decompressing to Classical by Philip Glass on a Rainy Joshua Tree Weekend https://steemit.com//recordpool/@mateonav53/steemit-recordpool-decompressing-to-classical-by-philip-glass-on-a-rainy-joshua-tree-weekend	@mateonav53	109	1	0.4760
Steem Music : Fly Me To The Moon https://steemit.com//steem-music/@sireh/steem-music-fly-me-to-the-moon	@sireh	107	12	8.8000
SONG OF THE DAY//RECORDPOOL//JAMES BROWN//FUNKY DRUMMER https://steemit.com//hiphoptheblockchain/@bboyady/song-of-the-day-recordpool-james-brown-funky-drummer	@bboyady	106	1	3.7670
#recordpool Weekly Analysis Report #8 (Weekly Contest #11) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-8-weekly-contest-11	@superoo7	103	8	1.5630
Song of the Day - Thomas, You're the Leader https://steemit.com//recordpool/@asherlee/song-of-the-day-thomas-you-re-the-leader	@asherlee	81	3	1.6730
SONG OF THE DAY//RECORDPOOL//PENTATONIX//HAPPY https://steemit.com//songoftheday/@bboyady/song-of-the-day-recordpool-pentatonix	@bboyady	79	2	1.6810
Ason Intrigue - Summertime's Blue Sumday Rad Mix https://steemit.com//dsound/@asonintrigue/20180326t220035147z-ason-intrigue-summertimes-blue-sumday-rad-mix	@asonintrigue	78	26	5.6890
Cop While You Can: New and Limited Vinyl Releases https://steemit.com//recordpool/@warmcracklesound/cop-while-you-can-new-and-limited-vinyl-releases	@warmcracklesound	78	1	2.0460
Song of the Day: Itro - Up https://steemit.com//recordpool/@danielwong/song-of-the-day-itro-up	@danielwong	76	3	17.2400
Blogging Around Day 71: Evolution of Aristos Petros https://steemit.com//blog/@jpederson96/blogging-around-day-71-evolution-of-aristos-petros	@jpederson96	62	5	8.9610

in terms of comments

Title	Author	Upvotes	Comments	Payout
Steemit Open Mic Week 78 🎵 | Beyonce: Listen |🎻 https://steemit.com//openmic/@silentscreamer/znifwtme	@silentscreamer	56	48	33.2280
Ason Intrigue - Summertime's Blue Sumday Rad Mix https://steemit.com//dsound/@asonintrigue/20180326t220035147z-ason-intrigue-summertimes-blue-sumday-rad-mix	@asonintrigue	78	26	5.6890
'Steemit Record Pool' Weekly Roundup Contest Winners #10 | Curate Music & Win Rewards! https://steemit.com//music/@recordpool/steemit-record-pool-weekly-roundup-contest-winners-10-or-curate-music-and-win-rewards	@recordpool	49	25	12.6020
Steem Music : Fly Me To The Moon https://steemit.com//steem-music/@sireh/steem-music-fly-me-to-the-moon	@sireh	107	12	8.8000
Steemit Recordpool: Addicted to this Perplexing Horn-laced Beat by Outkast "SpottieOttieDopaliscious" https://steemit.com//recordpool/@mateonav53/steemit-recordpool-addicted-to-this-perplexing-horn-laced-beat-by-outkast-spottieottiedopaliscious	@mateonav53	16	11	0.3540
#recordpool Weekly Analysis Report #8 (Weekly Contest #11) https://steemit.com//recordpool/@superoo7/recordpool-weekly-analysis-report-8-weekly-contest-11	@superoo7	103	8	1.5630
Curator Roundtable #1 https://steemit.com//curator/@zingali/curator-roundtable-1	@zingali	12	6	0.3270
BEST NEW MUSIC: Toshio Matsuura Group - Brown Paper Bag [jazz drum n' bass live band cover] https://steemit.com//music/@rawselectmusic/best-new-music-toshio-matsuura-group-brown-paper-bag-jazz-drum-n-bass-live-band-cover	@rawselectmusic	12	5	0.2850
Blogging Around Day 71: Evolution of Aristos Petros https://steemit.com//blog/@jpederson96/blogging-around-day-71-evolution-of-aristos-petros	@jpederson96	62	5	8.9610
Song of the day - Through The Barricades https://steemit.com//recordpool/@grayarty/song-of-the-day-through-the-barricades	@grayarty	26	4	2.1100

SQL Queries

I changed the query this week, where the SQL Query performance had increase significantly.

Details about it at SteemSQL - New Full Text Search indexed json_metadata by @arcange

Overall Stats

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,'07/01/2017') AND
  created< CONVERT(datetime,'04/02/2018') AND
  depth = 0 AND
  ISJSON(json_metadata) > 0 AND
  CONTAINS(json_metadata, 'recordpool')

Weekly Stats

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,'03/26/2018') AND
  created< CONVERT(datetime,'04/02/2018') AND
  depth = 0 AND
  ISJSON(json_metadata) > 0 AND
  CONTAINS(json_metadata, 'recordpool')

Weekly Top Author

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,'03/26/2018') AND
 created< CONVERT (datetime, '04/02/2018')
GROUP BY
   Author
ORDER BY
 Posts DESC

Top Post

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,'03/26/2018') AND
  created< CONVERT(datetime,'04/02/2018') AND
  depth = 0 AND
  ISJSON(json_metadata) > 0 AND
  CONTAINS(json_metadata, 'recordpool')
ORDER BY
  Upvotes desc