Welcome to weekly analysis of #recordpool.The purpose of this analysis is to determine the weekly winner for #recordpool from 19/03/2018 - 25/03/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!"](https://steemit.com/recordpool/@djlethalskillz/steemit-record-pool-new-community-contest-update-curate-music-and-win-weekly-whaleshares-and-hairshares)


The announcement of the winner will be done by @recordpool.

![](https://steemitimages.com/DQmcyoChzfJ5UZSkZngGmRcvAbJJXEveHSWyfb14ncFRLSE/image.png)

> All data are queried from SteemSQL until 18/03/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)

# Overall Statistics

<table border="1" style="border-collapse:collapse">
<tr><th>Author</th><th>Posts</th><th>Upvotes</th><th>Comments</th><th>Payout</th></tr>
<tr><td>112</td><td>1023</td><td>21005</td><td>3957</td><td>3701.6640</td></tr></table>



# Weekly Statistics (19/03/2018 - 25/03/2018)

<table border="1" style="border-collapse:collapse">
<tr><th>Author</th><th>Posts</th><th>Upvotes</th><th>Comments</th><th>Payout</th></tr>
<tr><td>24</td><td>61</td><td>1445</td><td>129</td><td>160.8430</td></tr></table>
</body>

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

<table border="1" style="border-collapse:collapse">
<tr><th>Author</th><th>Posts</th><th>Upvotes</th><th>Comments</th><th>Payout</th></tr>
<tr><td>@calisay</td><td>8</td><td>54</td><td>9</td><td>6.2460</td></tr>
<tr><td>@mateonav53</td><td>7</td><td>365</td><td>10</td><td>6.9360</td></tr>
<tr><td>@inthenow</td><td>7</td><td>190</td><td>9</td><td>2.8300</td></tr>
<tr><td>@danstatus</td><td>5</td><td>45</td><td>9</td><td>64.0420</td></tr>
<tr><td>@fourfourfun</td><td>4</td><td>75</td><td>11</td><td>6.8240</td></tr>
<tr><td>@iamevilradio</td><td>4</td><td>31</td><td>13</td><td>1.5410</td></tr>
<tr><td>@asonintrigue</td><td>3</td><td>53</td><td>5</td><td>1.9880</td></tr>
<tr><td>@rawselectmusic</td><td>3</td><td>52</td><td>11</td><td>9.2040</td></tr>
<tr><td>@bboyady</td><td>2</td><td>125</td><td>9</td><td>4.4840</td></tr>
<tr><td>@grayarty</td><td>2</td><td>61</td><td>14</td><td>4.9580</td></tr></table>




## Weekly Top 10 posts

### In terms of upvotes

<table border="1" style="border-collapse:collapse">
<tr><th>Title</th><th>Author</th><th>Upvotes</th><th>Comments</th><th>Payout</th></tr>
<tr><td>Steemit Recordpool: A Love Song With Minimal Words - &quot;Friday Morning&quot; by Khruangbin https://steemit.com//recordpool/@mateonav53/steemit-recordpool-a-love-song-with-minimal-words-friday-morning-by-khruangbin</td><td>@mateonav53</td><td>110</td><td>1</td><td>0.5540</td></tr>
<tr><td>Steemit Recordpool: Saturday-Night-Live-Sax Mixed With Some House https://steemit.com//recordpool/@mateonav53/steemit-recordpool-saturday-night-live-sax-mixed-with-some-house</td><td>@mateonav53</td><td>107</td><td>2</td><td>0.3730</td></tr>
<tr><td>Song of the Day | Edition #9 https://steemit.com//recordpool/@lost108/song-of-the-day-or-edition-9</td><td>@lost108</td><td>101</td><td>2</td><td>1.8770</td></tr>
<tr><td>Song of the Day - Say Something https://steemit.com//recordpool/@calebleejl/song-of-the-day-say-something</td><td>@calebleejl</td><td>90</td><td>1</td><td>2.0430</td></tr>
<tr><td>SONG OF THE DAY//RECORDPOOL//OLD SCHOOL FUNKY FAMILY //PING PONG https://steemit.com//recordpool/@bboyady/song-of-the-day-recordpool-old-school-funky-family-ping-pong</td><td>@bboyady</td><td>66</td><td>4</td><td>2.5370</td></tr>
<tr><td>Steemit Recordpool: You Can&#39;t Deny The Saxy Pleasure of &quot;Contrast&quot; by Bells &amp; Robes feat. Clark Smith https://steemit.com//recordpool/@mateonav53/steemit-recordpool-you-can-t-deny-the-saxy-pleasure-of-contrast-by-bells-and-robes-feat-clark-smith</td><td>@mateonav53</td><td>63</td><td>0</td><td>2.7590</td></tr>
<tr><td>SONG OF THE DAY//RECORDPOOL//WHO DO IT BETTER//JOE FLIZZOW,ALTIMET&amp;SONAONE https://steemit.com//recordpool/@bboyady/song-of-the-day-recordpool-who-do-it-better-joe-flizzow-altimet-and-sonaone</td><td>@bboyady</td><td>59</td><td>5</td><td>1.9470</td></tr>
<tr><td>GrayBlogicle #4 - Being Liberal at Liberal Latte https://steemit.com//steem-music/@grayarty/grayblogicle-4-being-liberal-at-liberal-latte</td><td>@grayarty</td><td>55</td><td>11</td><td>3.9660</td></tr>
<tr><td>Song of the Day: Tobu &amp; Itro - Magic https://steemit.com//recordpool/@danielwong/song-of-the-day-tobu-and-itro-magic</td><td>@danielwong</td><td>53</td><td>3</td><td>1.8880</td></tr>
<tr><td>Song of the Day - Do Cheiro de Alecrim a Lembrança do Amanhã - Gui Siveiras https://steemit.com//recordpool/@guifaquetti/song-of-the-day-do-cheiro-de-alecrim-a-lembranca-do-amanha-gui-siveiras</td><td>@guifaquetti</td><td>45</td><td>7</td><td>0.3530</td></tr></table>

### In terms of comments

<table border="1" style="border-collapse:collapse">
<tr><th>Title</th><th>Author</th><th>Upvotes</th><th>Comments</th><th>Payout</th></tr>
<tr><td>GrayBlogicle #4 - Being Liberal at Liberal Latte https://steemit.com//steem-music/@grayarty/grayblogicle-4-being-liberal-at-liberal-latte</td><td>@grayarty</td><td>55</td><td>11</td><td>3.9660</td></tr>
<tr><td>RAW SELECT RAMEN REVIEW! https://steemit.com//steemit/@rawselectmusic/raw-select-ramen-review</td><td>@rawselectmusic</td><td>27</td><td>9</td><td>5.2410</td></tr>
<tr><td>Song of the Day - Do Cheiro de Alecrim a Lembrança do Amanhã - Gui Siveiras https://steemit.com//recordpool/@guifaquetti/song-of-the-day-do-cheiro-de-alecrim-a-lembranca-do-amanha-gui-siveiras</td><td>@guifaquetti</td><td>45</td><td>7</td><td>0.3530</td></tr>
<tr><td>{review} Antenna - New Life https://steemit.com//electronicmusic/@fourfourfun/review-antenna-new-life</td><td>@fourfourfun</td><td>12</td><td>7</td><td>0.6720</td></tr>
<tr><td>Steemit Record Pool | Song of The Day 68 | Big Tings - Skindred https://steemit.com//recordpool/@inthenow/steemit-record-pool-or-song-of-the-day-68-or-big-tings-skindred</td><td>@inthenow</td><td>27</td><td>6</td><td>0.2030</td></tr>
<tr><td>Final Song Community Playlist Challenge https://steemit.com//finalsong/@iamevilradio/final-song-community-playlist-challenge</td><td>@iamevilradio</td><td>9</td><td>6</td><td>0.7860</td></tr>
<tr><td>SONG OF THE DAY//RECORDPOOL//WHO DO IT BETTER//JOE FLIZZOW,ALTIMET&amp;SONAONE https://steemit.com//recordpool/@bboyady/song-of-the-day-recordpool-who-do-it-better-joe-flizzow-altimet-and-sonaone</td><td>@bboyady</td><td>59</td><td>5</td><td>1.9470</td></tr>
<tr><td>Steemit Recordpool: Arcade Fire Kills it on Saturday Night Live with &quot;Creature Comfort&quot; https://steemit.com//recordpool/@liz-creates/steemit-recordpool-arcade-fire-kills-it-on-saturday-night-live-with-creature-comfort</td><td>@liz-creates</td><td>27</td><td>5</td><td>7.5230</td></tr>
<tr><td>Scuzzy&#39;s Digest #9 | Steemit Record Pool https://steemit.com//curate/@recordpool/scuzzy-s-digest-9-or-steemit-record-pool</td><td>@recordpool</td><td>26</td><td>5</td><td>0.4490</td></tr>
<tr><td>Song of the Day - The Day The Earth Stood Still by Pleasurekraft https://steemit.com//recordpool/@iamevilradio/song-of-the-day-the-day-the-earth-stood-still-by-pleasurekraft</td><td>@iamevilradio</td><td>8</td><td>5</td><td>0.2470</td></tr></table>

# SQL Queries
In case anyone interested in the SQL Queries I used.

## Weekly Stats

```
SELECT
 COUNT(DISTINCT 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
     parent_author = '' AND
     created >= CONVERT(datetime,'03/19/2018') AND
     created< CONVERT(datetime,'03/26/2018') AND
     depth = 0 AND
     ISJSON(json_metadata) > 0 AND
     'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
```

## Top Author

```
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
     parent_author = '' AND
     created >= CONVERT(datetime,'03/19/2018') AND
     created< CONVERT(datetime,'03/26/2018') AND
     depth = 0 AND
     ISJSON(json_metadata) > 0 AND
     'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
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/19/2018') AND
 created< CONVERT(datetime,'03/26/2018') AND
 depth = 0 AND
 ISJSON(json_metadata) > 0 AND
 'recordpool' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
ORDER BY
  Upvotes desc
```