🌞#BeautifulSunday - Powered up Winners for the week with help of steemsql | 美丽星期天 - 这周赢家找了steemsql帮手 (by @ace108)

in #beautifulsunday7 years ago (edited)

Sunday Hug
Photo source from Pixabay.com

Last #beautifulsunday | 上个美丽星期天

Here’s the update on the participation for #beautifulsunday for last Sunday. Again, I’ll continue to highlight that there are posts that I did not qualify and it has go to do with the criteria. Chances are your #beautifulsunday posts didn’t qualify if you have less than 2 images or didn’t post on Sunday. I am using steemsql.com to figure the #beautifulsunday posts and sort it by pending payout value, checking out #beautifulsunday is easier. There are 2 #beautifulsunday posts with pending rewards above $100. To me, the good news is there more than 20 qualifying posts this week. See?
现在,又来报道上周日的#beautifulsunday结果。 首先再次强调,有些帖子我没算达标。如果你的帖有少于2张图片或不是在星期天发布,我就认为不符合规则。我会用 steemsql.com 找出美丽星期天#beautifulsunday的帖导致看看美丽星期天也轻松多了。这星期有2帖等待多过$100奖励。好消息是又多过20达标帖。看看。
Author Pending Payout #beautifulsunday Posts Tags
@jennswall 0.35 THE WORLD IS A BOOK, READ MORE THAN JUST ONE PAGE. Happy BeautifulSunday Steemit #photography
#life
#art
#travel
@shaunf 0.515 What do you know, its already time for another beautiful sunday #beautifulsunday
#tsufamily
#photography
#travel
#canada
@torem-di-torem 0.76 BeautifulSunday: Rainbow tail #beautifulsunday
#photography
#nature
#life
#blog
@hajevoy60 1.04 A Beautiful Sunday - My little daughter and I were riding in the waves in the sea. #beautifulsunday
#photography
#life
#nature
#ua
@watersnake101 1.268 Morning Walk Back Thru Time - Beautiful Sunday #beautifulsunday
#photography
#blog
#life
#contest
@theia7 1.997 Beautiful Sunday at El Paso Zoo #beautifulsunday
#photography
#nature
#life
#animal
@decentropia 2.455 Beautiful Sunday: A visit to a Texas Farmland- Majestic Texas Longhorn #photography
#beautifulsunday
#nature
#travel
@olga.maslievich 5.413 Beautiful Sunday on the wall of an ancient fortress on the banks of the mouth of the Dniester! 4 fascinating photos of my trip to the South of Ukraine. #travel
#beautifulsunday
#photography
#life
#ua
@sulev 5.954 #48 EVENING SHOTS [11 photos for your viewing pleasure] ─=≡Σ((( つ•̀ω•́)つLET’S GO! #evening
#photography
#beautifulsunday
#minnowsunite
#whalepower
@sulev 6.121 Sunday Street Cafe "Belly Button" #photography
#beautifulsunday
#life
#whalepower
#street
@shady 9.108 Beautiful Sunday - Family Pizza - Evening #beautifulsunday
#photography
#life
#travel
#ua
@sardrt 21.363 Around the churches of my City. Cagliari, Italy. (Photos by sard@rt) #travel
#beautifulsunday
#italy
#culture
#photography
@jlufer 22.798 Beautiful Sunday (Celebrating the Universal Day of the Child) #beautifulsunday
#photography
#life
@batwing 24.216 Temples - The House Of The Lord #beautifulsunday
#history
#photography
#architecture
#blog
@uwelang 40.148 Beautiful Sunday in the Fairytale Park #photography
#beautifulsunday
#education
#community
#life
@wanderwithtwo 95.038 Wander with us to: Queen Victoria Building @ Sydney, Australia | 跟我们去:維多利亞女王大厦 @ 悉尼,澳大利亚 #travel
#cn
#photography
#beautifulsunday
#story
@joythewanderer 121.968 “Car-Free” Sunday - Fun events in town “无车日”文化活动的有趣体验 #life
#cn
#story
#beautifulsunday
#steemit
@crazymumzysa 124.807 Beautiful Sunday - Rainbows Over The Ocean #beautifulsunday
#photography
#rainbows
#science
#nature
SEPARATOR-Sun Smile

People who have participated in #BeautifulSunday since beginning | 从始有参加过#BeautifulSunday的人

The payout here includes both paid and pending amount.
这里的奖励包括已付和未付项。
Author
作者
No. of Post
帖数
Min Payout
最低奖励
Average Payout
平均奖励
Max Payout
最高奖励
@ace108 39 5.013 39.5971 246.496
@adrianobalan 1 0.6 0.6 0.6
@ai-max 2 6.627 18.916 31.205
@allmonitors 1 3.846 3.846 3.846
@amazona06 1 0.092 0.092 0.092
@andr1an0 1 0.621 0.621 0.621
@barbara-orenya 6 1.529 18.8518 89.459
@batwing 7 13.941 23.3021 32.093
@blacktranquility 1 0.119 0.119 0.119
@brianphobos 2 8.683 14.186 19.689
@ck-cake 1 8.442 8.442 8.442
@cornflakes 1 6.663 6.663 6.663
@crazymumzysa 1 124.807 124.807 124.807
@cryptastic 4 2.763 8.092 11.356
@dabeckster 1 0.286 0.286 0.286
@darkqueen 1 0.612 0.612 0.612
@decentropia 1 2.455 2.455 2.455
@duremarr 1 0.229 0.229 0.229
@edje 1 3.769 3.769 3.769
@ervin-lemark 1 3.365 3.365 3.365
@foodie.warrior 5 3.238 4.5372 5.522
@hajevoy60 1 1.04 1.04 1.04
@htliao 3 59.152 61.1003 63.118
@ir3k 1 0.622 0.622 0.622
@jamesvmaxx 1 0.135 0.135 0.135
@jeevesix 2 0.466 1.077 1.688
@jennswall 3 0.01 0.129 0.35
@joythewanderer 8 44.207 85.71 141.49
@lassep 1 6.719 6.719 6.719
@liliana.duarte 1 14.857 14.857 14.857
@livewell 1 0.608 0.608 0.608
@ma1neevent 6 0.66 5.0791 11.515
@mikegun 1 5.684 5.684 5.684
@molometer 1 0.447 0.447 0.447
@ninahaskin 2 0.562 0.8195 1.077
@old-guy-photos 9 2.479 8.455 16.422
@olga.maslievich 11 5.036 12.3116 50.136
@pakyeechan 1 7.64 7.64 7.64
@pipurilla 2 4.123 4.4925 4.862
@pradeep99 2 0.016 0.1915 0.367
@puffin 1 12.12 12.12 12.12
@rafadezelanda 1 0.049 0.049 0.049
@sabine-reichert 1 5.195 5.195 5.195
@sardrt 2 11.251 16.307 21.363
@shaunf 9 0.515 0.8897 1.604
@shenchensucc 2 20.888 37.083 53.278
@solarguy 2 6.797 8.2695 9.742
@speedygonzales 1 3.742 3.742 3.742
@sulev 6 3.798 7.9851 14.28
@susanlo 1 75.004 75.004 75.004
@svinsent 1 0.61 0.61 0.61
@sweetieprincess 1 3.518 3.518 3.518
@sweetpea 1 0.588 0.588 0.588
@theia7 1 1.997 1.997 1.997
@torem-di-torem 1 0.76 0.76 0.76
@travelgirl 1 31.881 31.881 31.881
@uwelang 5 21.608 28.1264 40.148
@wanderwithtwo 1 95.038 95.038 95.038
@watersnake101 3 1.268 2.6186 4.393
@wilkinshui 1 29.159 29.159 29.159

To learn about other people’s #beautifulsunday, click the link below.
您可以点击下面的链接了解其他人的美丽星期天#beautifulsunday。

https://steemit.com/created/beautifulsunday

SEPARATOR-Sun Smile

Beautiful Sunday Challenge - NEW RULES
美丽星期天行动 - 新规则

I started the #beautifulsunday challenge hoping to people share beautiful story on sunday with at least 2 images with the intent to reward the post with beautiful story which are having low reward. Details of the new rules in this post.
我开始了美丽星期天#beautifulsunday发帖行动,希望能够有多点人在星期日分享美丽故事并用至少2张图片以便奖励那些回报低的帖。新规则的细节在这帖。
FIRST12
🌞#BeautifulSunday - Winner and New Rules | 美丽星期天 - 赢家和新规则
SEPARATOR-Sun Smile

Winners of Beautiful Sunday Challenge | 美丽星期天行动赢

There are 3 posts with low pending reward. Base on the criteria I mentioned in the “New Rules” post, I have chosen the following as winners and sent 0.3 steem to each of them to power up their account.
我看到3个等待少奖励的帖。我选择了以下用户作为获奖者,并送出0.3steem加强他们的户口。
@jennswall 0.35 THE WORLD IS A BOOK, READ MORE THAN JUST ONE PAGE. Happy BeautifulSunday Steemit
@shaunf 0.515 What do you know, its already time for another beautiful sunday
@torem-di-torem 0.76 BeautifulSunday: Rainbow tail

If you have a post tagged with #beautifulsunday but did not qualify, you should re-read the criteria.
如果你的帖子标有#beautifulsunday但没被录取,你应该重新阅读规则。

SEPARATOR-Sun Smile

Reminder | 提示

Still Calling for participation in revised edition. 还在呼吁参加升级版。



To see the latest #beautifulsunday posts, click the link below..
要查看最新的美丽星期天帖,请点击以下链接。
https://steemit.com/created/beautifulsunday
Remember Beautiful Sunday
IMAGE LINK|图片链接: https://supload.com/H1oSNJheZ

SEPARATOR-Sun Smile
Recent Post
FIRST3
📷🚗Color Challenge, Tuesday Orange - Buses and more at Sentosa | 圣陶沙之公车加
FIRST4
Meme challenge # 32 - Watch dog
FIRST5
📊🌏中日韩龙虎榜自20170826 | CJK Top Pending Payout Post since 20170826
FIRST6
📸 #monomad Week No. 8 - Tuesday - United Temple in mono | 黑白照片比赛第8周-星期2 - 五合庙
FIRST7
📊[IMPROVED] Top 20 Level 1 commenters for 20170828, active hours and how their comments looks like
FIRST8
📸 #monomad Week No. 8 - Monday - Former Supreme Court | 黑白照片比赛第8周-星期一 - 以前的高等法院
FIRST9
📊🌏中日韩龙虎榜自20170825 | CJK Top Pending Payout Post since 20170825
SEPARATOR-Dolphins In on Blue
Please see my other posts: @ace108
请看我其他帖: @ace108

Separator-ACE-800

I See👀. I Shoot📷. I Steemit♨️.


Sort:  

I'm wondering how you came to the numbers for the second part of the post called (and I copied and pasted it) People who have participated in #BeautifulSunday since beginning | 从始有参加过#BeautifulSunday的人
The payout here includes both paid and pending amount.

It says you've done 39, equaling 39 weeks I guess, maybe a few were just talking about it, I can't scroll back that far, and I have only done 2.

Now, I know you know I have done more than 2. I have hit many sundays since you started this trend, though I know I have missed many as well.

At first I was like... "well, that's just recently" but your 39 vs my 2, as you mentioned in this post doesn't add up.

So how did you come up with that tally?

I used steemsql and query but some weeks I do more than 1 or 2. Thanks for bringing up. I think I should have excluded my count for the one I post for updates where I also included the tag. I have to check on my query and adjust. :-)

I dont know how i missed this reply. You do good work and i enjoy ur updates

No worries. I think I missed replies too. I think I need to figure out query to find comments I had not reply but busy with too many things now. :-) but I have adjusted the stats query based on your feedback.
Have a #beautifulsunday

sir you are great. i upvote you plaese upvote me.
god bless you.

Steem is $1.5 at the moment.

Hi @ace108, Is this challenge only for Chinese users or anyone can participate?

It's for anyone but I read only English and Chinese :-)

great post my dear friend please visit my page thanks alot

You're welcome and thanks for visiting

可惜没有赶上这一期

现在赶下一期吧。 :-)

I didn't get to participate this Sunday. I have been super busy. Maybe next Sunday.

Busy is good Sunday. Good to have you for #beautifulsunday again.

Congratulations to all the winners of this period and to all those people who have participated in this fun event.
Thank you very much dear friend @ ace108 for this initiative, and give them the opportunity to post our Sundays.
Have a great day

Thanks for coming by. :-)

Congrats to the winners! I appreciate you hosting this challenge. I was gone all Sunday to a Renaissance Festival but look forward to the next one!

Ah, I've been one when i was Kansas City years ago. Heard someone said that's a travelling fair. Time to share that #beautifulsunday.

Congrats to the winners!

Thanks for coming by to congratulate

Thank you @ace108 for recognizing my work! Have a nice day!

Coin Marketplace

STEEM 0.17
TRX 0.12
JST 0.028
BTC 56420.74
ETH 2938.55
USDT 1.00
SBD 2.22