Who is the winner? | 谁是赢家？
IMAGE LINK|图片链接: https://supload.com/BJewu-AVef
Image source: www.pixabay.com

So you ran a contest and people are supposed to leave a comment with the guess/answer. Now, how do you figure out who came and what comment? This was the post in which I had a contest recent:

那你举办了一场比赛或游戏，人们应该对猜测/答案留言。 现在，又如何知道谁参于和谁和谁的答案？这是我最近参加比赛的帖：

📷#colorchallenge #yellowwednesday #dailyfoodphotography • and chance to WIN 8 steem | 赢8Steem游戏

🎶Meanwhile, some music for you to enjoy as you read. This piece is part of Vivaldi’s The Four Seasons, particular the first of the 4 violin concertos, called Winter.

🎶让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“冬天”。

Source | 来源: https://musopen.org/

Working on the result… | 找出结果。。。

First, take a look at my last contest and note the Title and the link.

首先，看看我的游戏帖，注意标题和链接。

Title: 📷#colorchallenge #yellowwednesday #dailyfoodphotography • and chance to WIN 8 steem | 赢8Steem游戏 (by @ace108)
Link: https://steemit.com/colorchallenge/@ace108/colorchallenge-yellowwednesday-dailyfoodphotography-and-chance-to-win-8-steem-or-8steem-by-ace108#@homeartpictures/re-ace108-colorchallenge-yellowwednesday-dailyfoodphotography-and-chance-to-win-8-steem-or-8steem-by-ace108-20171122t074233205z
Then, let's find the level 1 comment on that post with this SQL.

然后，让我们用这个SQL找到关于该帖的第1层留言。

select 
cmd.created created_wo_time, 
'@' + cmd.author commenter, 
cmd.body Full_comments
from 
   Comments cmd WITH (NOLOCK)
where 
    ( cmd.depth = 1)
and (cmd.root_title like '%#colorchallenge #yellowwednesday #dailyfoodphotography%and chance to WIN 8 steem%|%by @ace108)%')     ---- POST TITLE
and cmd.parent_author = 'ace108'
order by 
created_wo_time desc, commenter 

Notice the condition for root_title. I did that to avoid the emoji and non-English characters which sometimes don't work very well but I'm sure it gets the comment for my contest post.

注意 root_title 的条件。 我这样做是为了避免表情符号和非英文字符，这些字符有时候给不好的效果，但是我相信这会得到我要看的留言。

Now, who gave the answer according to the format I want which I consider as participating. Let's fine tune the SQL. I want the comment like '%1%2%3%' to be considered as entry. But who then is the winner? My answer is 1-F 2-S 3-A. That means must fine tune the SQL some more so the comment must be like '%1%F%2%S%3%A%'. Were there any? Let’s see my updated SQL query.

现在，谁按照我规定的模式提交答呢？我们调整之前的SQL，我要有“％1％2％3％”这样的留言。 但那谁是赢家呢？ 我的答案是1-F 2-S 3-A。 这指必须再调我的SQL，所以留言必须是'％1％F％2％S％3％A％'模式。有没有？ 让我们看看我更新的SQL查询。

select 
cmd.created created_wo_time, 
'@' + cmd.author commenter, 
cmd.body Full_comments,
case when 
    ( cmd.body like '%1%2%3%' )
then
    'Yes' 
else 
    'No'
end Entry,
case when 
    ( cmd.body like '%1%F%2%S%3%A%' )
then
    'Maybe' 
else 
    'No Way'
end Right_Answer
from 
   Comments cmd WITH (NOLOCK)
where 
    ( cmd.depth = 1)
and (cmd.root_title like '%#colorchallenge #yellowwednesday #dailyfoodphotography%and chance to WIN 8 steem%|%by @ace108)%')     ---- POST TITLE
and cmd.parent_author = 'ace108'
order by 
created_wo_time desc, commenter 

I ran it and exported to Excel and look.

我跑了这SQL把结果输出到 Excel 去看看。

IMAGE LINK|图片链接:
The “Entry” column looks like need improvement. Anyone has any suggestion?/

“Entry”那列好像有问题。有朋友提议怎么改进吗？

3 “Maybe”s. Is there a tie?

3 个“Maybe”=”可能”。需要打破僵局吗？

In the contest, the food photo quite obviously included rice and vegetables but the meat was what I thought will be doubtful. A couple guess chicken and the answer is fish.

在游戏里，照片很明显包含了米饭和蔬菜，但肉就可能难猜点。 两人有提到鸡。答案是鱼。

Thanks to the following people who participated:

感谢以下参与的玩家:

@ekaterinka
@blazing
@travelgirl
@momskitchen
@floatinglin
@amsakhan
@fr3eze
@betterthanhome
@meesterboom
@chann
@akilasultana373
@homeartpictures


Therefore, the winner is @fr3eze. No mention of resteem and I’m too lazy to do any query but a quick shows no resteem. So, no bonus 1 steem.

结果，赢家是 @fr3eze . 留言没说有否用resteem分享帖而我有懒得再写多个SQL但很快看出是没有。所以每附加多1 steem 奖励。

IMAGE LINK|图片链接:

Conclusion is need some improvement to the process. Maybe better format required for the answer submission. Let me rest a while before I send the prize out. I had bad day yesterday. Should be out before tomorrow afternoon.

结论是需要一些改进的过程。 也许需更好的格式所来做答案提交。让我休息再把奖品送出。昨天可真有点烦。应该在明天中午前送出。

📊🌏中日韩龙虎榜自20171120 | CJK Top Pending Payout Post since 20171120

📸 bwphotocontest Entry - Summer Read | 黑白照片比赛作品 - 夏阅

📊[IMPROVED] Top 20 Level 1 commenters for 20171122, active hours and how their comments looks like

Spotted a bug in reply tab? I think so

📊🌏中日韩龙虎榜自20171119 | CJK Top Pending Payout Post since 20171119

📷#colorchallenge #yellowwednesday #dailyfoodphotography • and chance to WIN 8 steem | 赢8Steem游戏

📊[IMPROVED] Top 20 Level 1 commenters for 20171121, active hours and how their comments looks like

Saw some classic cars last Saturday | 上周六,看到经典车

Please see my other posts: @ace108

请看我其他帖: @ace108

---

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