#recordpool Weekly Analysis Report #1

crisdevilgamer (12)in #teammalaysiastats • 7 years ago (edited)

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 @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 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

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

https://steemit.com/@crisdevilgamer

#analysis #busy #contest #ptmusic

7 years ago in #teammalaysiastats by crisdevilgamer (12)

$0.00

8 votes

Sort:

Trending

[-]

inthenow (64) 7 years ago

Hello @crisdevilgamer it looks like you have not been around long enough here on Steemit to know better. And if you have and this is a second account, then your actions are messed up on many levels. Either way, I am going to do you a favor...

Lesson #1: Do Not Steal Other Peoples Posts And Re-post Them As Your Own. If You Continue Down This Path, You Will Only Hurt Yourself In The Long Run.

Lesson #2: Think Of Other People Before Yourself. Create Original Content, Comment On Others Posts With Sincerity And Upvote, Give More Than You Take Here On Steemit.

Follow this lesson plan, otherwise you will find yourself is a sea of misery. Have a lovely day.

$0.00