create account

#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108) by ace108

View this thread on: hive.blog |  peakd.com |  ecency.com
cn · @ace108 · (edited)
$123.92
#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)
<html>



<br>

In this previous post where I shared my dinner, I asked to guess how much I paid for dinner:
<blockquote>
之前的这一帖里，我要大家猜猜那晚餐花了我多少钱。
</blockquote>
<table>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/ByfiIbzrrZ.jpg" alt="FIRST14" border="0"></div><a href="https://steemit.com/beautifulsunday/@ace108/beautifulsunday-eatwithme-before-the-close-encounter-of-the-matcha-cake-or-by-ace108" target="_blank">#BeautifulSunday. #Eatwithme. Before the close encounter of the matcha cake | 亲密接触抹茶蛋糕之前 </a></td></tr>
</table>

<h3>
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 Summer. 
<blockquote>
让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“夏天”。
</blockquote>
Source | 来源: <a
href="https://musopen.org/"
target="_blank">https://musopen.org/</a><br>
</h3>
<iframe width="100%" height="450" scrolling="no" frameborder="no" src="https://w.soundcloud.com/player/?url=https%3A//api.soundcloud.com/tracks/303627467&amp;auto_play=false&amp;hide_related=false&amp;show_comments=true&amp;show_user=true&amp;show_reposts=false&amp;visual=true"></iframe>
Source: https://musopen.org/music/2213/antonio-vivaldi/the-four-seasons/
Violin Concerto in G minor, RV 315 'Summer' - Complete Concerto

<center>
<h1>Reviewing what I ate again | 再看看之前吃过的</h1>
</center>

Green tea. 
<blockquote>
绿茶。
</blockquote>
<center><img src="https://i.supload.com/SJeiIZfSS-.jpg" alt="SSS100" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/SJeiIZfSS-">https://supload.com/SJeiIZfSS-</a><br><br>


Fried chicken.
<blockquote>
炸鸡。
</blockquote>
<center><img src="https://i.supload.com/BJZoUbMSS-.jpg" alt="SSS110" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/BJZoUbMSS-">https://supload.com/BJZoUbMSS-</a><br><br>


Gyozas.
<blockquote>
锅贴。
</blockquote>
<center><img src="https://i.supload.com/BJXoIbGBSZ.jpg" alt="SSS130" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/BJXoIbGBSZ">https://supload.com/BJXoIbGBSZ</a><br><br>


Maki.
<blockquote>
寿司。
</blockquote>
<center><img src="https://i.supload.com/rJrsU-MBr-.jpg" alt="SSS150" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/rJrsU-MBr-">https://supload.com/rJrsU-MBr-</a><br><br>


Chawan mushi.
<blockquote>
茶碗蒸。
</blockquote>
<center><img src="https://i.supload.com/BkltYWfHBW.jpg" alt="SSS160" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/BkltYWfHBW">https://supload.com/BkltYWfHBW</a><br><br>

Matcha cake.
<blockquote>
抹茶蛋糕。
</blockquote>
<center><img src="https://i.supload.com/HybKY-fHSZ.jpg" alt="SSS180" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/HybKY-fHSZ">https://supload.com/HybKY-fHSZ</a><br><br>



<h3>Recognise this cake now? <br>
认得这蛋糕了吗?
</h3>


<center>
<h1>Result of Guess and win | 猜测赢奖结果</h1>
</center>


The total price for the dinner was $36.60. Was your guess right or close?
<blockquote>
晚餐总消费$36.60. 你的猜测对或茶不多?
</blockquote>
<center><img src="https://i.supload.com/ByGU-oPH-.jpg" alt="SSS190" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/ByGU-oPH-">https://supload.com/ByGU-oPH-</a><br><br>





<br>
Now, for the #TIL, I learn to use steemsql.com to extract comments for the post.
<blockquote>
现在，学会了使用 steemsql.com 来提取对帖的回复。
</blockquote>
<center><img src="https://i.supload.com/Hyr11VCSW.png" alt="SSS10" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/Hyr11VCSW">https://supload.com/Hyr11VCSW</a><br><br>
Comparing the data and the comments and looks about right. 
<blockquote>

比较数据和回复。看来差不多。


</blockquote>
<center><img src="https://i.supload.com/SyDIkECBZ.png" alt="SSS20" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/SyDIkECBZ">https://supload.com/SyDIkECBZ</a><br><br>
Go through the data and find the winner.
<blockquote>
经过数据并找到获胜者。


</blockquote>
<center><img src="https://i.supload.com/H155WNCB-.png" alt="SSS30" border="0"></center>
IMAGE LINK|图片链接: <a href="https://supload.com/H155WNCB-">https://supload.com/H155WNCB-</a><br><br>



 <center>
<h1>The winner is @incrediblesnow | 获奖者是 @incrediblesnow</h1>
</center>
<table>
<tr><td>User</td><td>Comments</td><td>Price differences</td></tr>
<tr><td>@kitcat</td><td>I would guess $39.5! :)
delicious dishes!</td><td>2.9</td></tr>
<tr><td>@foodie.warrior</td><td>OMG I'm so hungry, and greener than the matcha cake!!

This is fun! I would guess, on average:
Rainbow maki - $11
Chawanmushi - $4
Tori Karaage - $9
Gyoza - $3.50
Green Tea - $2 each = $4
Matcha crepe cake = $5.50
Wet towels = $.40 each = $.80
TOTAL w/0 GST =$37.80
**TOTAL w GST OF 7% = $40.45**</td><td>3.85</td></tr>
<tr><td>@incrediblesnow</td><td>我猜$41</td><td>4.4</td></tr>
<tr><td>@travelgirl</td><td>I'll take a guess - $34.50 :)</td><td>2.1</td></tr>
</table>

Guess was not the exact total price. So, price to be transfer will be 1 steem.
<blockquote>
猜测不是最准确的全消费。所以，将送出的奖金是1 steem.
</blockquote>


<h3>Using steemsql.com helps quite a bit though there is still room for improvement in the process. 
<br>
使用steemsql.com帮助很多，虽然仍有改进的空间。
</h3>



<hr>
<center><img src="http://www.steemimg.com/images/2016/10/26/ACE108-SignaturePhoto167f6.png" alt="ACE108-SignaturePhoto167f6.png" border="0" /></center>

<table>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/http://i.imgur.com/snYkAIg.jpg" alt="FIRST2" border="0"></div><a href="https://steemit.com/steemitphotochallenge/@ace108/steemitphotochallenge-45-entry-3-yellow-bell-or-3-by-ace108" target="_blank">Steemitphotochallenge 📷 # 45 - Entry 3 Yellow Bell | 作品3 黄钟花 (）</a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/http://i.imgur.com/Bs765Xd.jpg" alt="FIRST3" border="0"></div><a href="https://steemit.com/yourcityvibez/@ace108/yourcityvibez-entry-ycv-8-waiting-for-fireworks-by-ace108" target="_blank">📸🏙 YourCityVibez Entry• YCV 8 - Waiting for fireworks </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/ryZpJy2QSb.jpg" alt="FIRST4" border="0"></div><a href="https://steemit.com/colorchallenge/@ace108/color-challenge-wednesday-yellow-my-tip-on-how-to-shoot-ice-cream-indoor-or-c-by-ace108" target="_blank">📷🍨Color Challenge, Wednesday Yellow - My tip on how to shoot ice cream indoor | 拍摄雪糕小贴士🍨 </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/BJW3e9oHb.jpg" alt="FIRST5" border="0"></div><a href="https://steemit.com/memechallenge/@ace108/meme-challenge-26-we-blog-and-get-paid-ace108" target="_blank">Meme challenge # 26 - We blog and get paid? (@ace108) </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/SJbxubiSZ.jpg" alt="FIRST6" border="0"></div><a href="https://steemit.com/treetuesday/@ace108/banana-trees-in-the-school-for-treetuesday-or-by-ace108" target="_blank">📷🌳Banana trees in the school for #treetuesday | 学校里的香蕉树 </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/http://i.imgur.com/7SHBswi.jpg" alt="FIRST7" border="0"></div><a href="https://steemit.com/bwphotocontest/@ace108/bwphotocontest-entry-1-singapore-marriott-tang-plaza-hotel-or-1-by-ace108" target="_blank">📸 bwphotocontest Entry 1 - Singapore Marriott Tang Plaza Hotel | 黑白照片比赛作品1 - 新加坡万豪酒店 </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/BySH2N9Hb.png" alt="FIRST8" border="0"></div><a href="https://steemit.com/memechallenge/@ace108/meme-challenge-26-frappucino-seriously-ace108" target="_blank">Meme challenge # 26 - Frappucino? Seriously? (@ace108) </a></td></tr>
<tr><td><div class=pull-right>
<img src="https://steemitimages.com/128x72/https://i.supload.com/r1AGFJFSb.jpg" alt="FIRST9" border="0"></div><a href="https://steemit.com/happydolphin/@ace108/1st-anniversary-49-sbd-giveaway-result-rep-71-recently-or-1-49sbd-71-by-ace108" target="_blank">🎆🎆🥂1st Anniversary 49 SBD Giveaway result - rep 71 recently | 1周年送49SBD奖结果 - 最近的信誉达71 </a></td></tr></table>









<hr>
Please see my other posts: @ace108<br>
<blockquote>请看我其他帖: @ace108 </blockquote>
<hr> 
<img src="http://www.steemimg.com/images/2016/10/26/ACE108-SignatureV1Bc45c8.gif" alt="ACE108-SignatureV1Bc45c8.gif" border="0" />
<br>

<a href="https://www.steemit.com/@ace108"><img
style="border: 0px solid ; width: 320px; height: 177px;"
src="http://www.steemimg.com/images/2016/08/31/FollowACE108-1cdc5f.gif"
alt="FollowACE108-1cdc5f.gif"></a>
<h3>I See👀. I Shoot📷. I Steemit♨️.</h3>
<br>


</html>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 69 others
properties (23)
authorace108
permlinktil-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108
categorycn
json_metadata{"tags":["cn","til","contest","food","photography"],"users":["incrediblesnow","kitcat","foodie.warrior","travelgirl","ace108"],"image":["https://steemitimages.com/128x72/https://i.supload.com/ByfiIbzrrZ.jpg","https://i.supload.com/SJeiIZfSS-.jpg","https://i.supload.com/BJZoUbMSS-.jpg","https://i.supload.com/BJXoIbGBSZ.jpg","https://i.supload.com/rJrsU-MBr-.jpg","https://i.supload.com/BkltYWfHBW.jpg","https://i.supload.com/HybKY-fHSZ.jpg","https://i.supload.com/ByGU-oPH-.jpg","https://i.supload.com/Hyr11VCSW.png","https://i.supload.com/SyDIkECBZ.png","https://i.supload.com/H155WNCB-.png","http://www.steemimg.com/images/2016/10/26/ACE108-SignaturePhoto167f6.png","https://steemitimages.com/128x72/http://i.imgur.com/snYkAIg.jpg","https://steemitimages.com/128x72/http://i.imgur.com/Bs765Xd.jpg","https://steemitimages.com/128x72/https://i.supload.com/ryZpJy2QSb.jpg","https://steemitimages.com/128x72/https://i.supload.com/BJW3e9oHb.jpg","https://steemitimages.com/128x72/https://i.supload.com/SJbxubiSZ.jpg","https://steemitimages.com/128x72/http://i.imgur.com/7SHBswi.jpg","https://steemitimages.com/128x72/https://i.supload.com/BySH2N9Hb.png","https://steemitimages.com/128x72/https://i.supload.com/r1AGFJFSb.jpg","http://www.steemimg.com/images/2016/10/26/ACE108-SignatureV1Bc45c8.gif","http://www.steemimg.com/images/2016/08/31/FollowACE108-1cdc5f.gif"],"links":["https://steemit.com/beautifulsunday/@ace108/beautifulsunday-eatwithme-before-the-close-encounter-of-the-matcha-cake-or-by-ace108","https://musopen.org/","https://musopen.org/music/2213/antonio-vivaldi/the-four-seasons/","https://supload.com/SJeiIZfSS-","https://supload.com/BJZoUbMSS-","https://supload.com/BJXoIbGBSZ","https://supload.com/rJrsU-MBr-","https://supload.com/BkltYWfHBW","https://supload.com/HybKY-fHSZ","https://supload.com/ByGU-oPH-","https://supload.com/Hyr11VCSW","https://supload.com/SyDIkECBZ","https://supload.com/H155WNCB-","https://steemit.com/steemitphotochallenge/@ace108/steemitphotochallenge-45-entry-3-yellow-bell-or-3-by-ace108","https://steemit.com/yourcityvibez/@ace108/yourcityvibez-entry-ycv-8-waiting-for-fireworks-by-ace108","https://steemit.com/colorchallenge/@ace108/color-challenge-wednesday-yellow-my-tip-on-how-to-shoot-ice-cream-indoor-or-c-by-ace108","https://steemit.com/memechallenge/@ace108/meme-challenge-26-we-blog-and-get-paid-ace108","https://steemit.com/treetuesday/@ace108/banana-trees-in-the-school-for-treetuesday-or-by-ace108","https://steemit.com/bwphotocontest/@ace108/bwphotocontest-entry-1-singapore-marriott-tang-plaza-hotel-or-1-by-ace108","https://steemit.com/memechallenge/@ace108/meme-challenge-26-frappucino-seriously-ace108","https://steemit.com/happydolphin/@ace108/1st-anniversary-49-sbd-giveaway-result-rep-71-recently-or-1-49sbd-71-by-ace108","https://www.steemit.com/@ace108"],"app":"steemit/0.1","format":"html"}
created2017-07-20 14:04:27
last_update2017-07-20 14:14:39
depth0
children31
last_payout2017-07-27 14:04:27
cashout_time1969-12-31 23:59:59
total_payout_value100.858 HBD
curator_payout_value23.061 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length8,711
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,080,805
net_rshares30,006,482,985,765
author_curate_reward""
vote details (133)
@ace108 · 
# Send in proccess | 送出途中...
![](https://steemitimages.com/DQmbCtnYnYCbg6Z61staMcKsDd7aasQxUMkx8GKAcDjY8FX/image.png)
👍  
properties (23)
authorace108
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t140615126z
categorycn
json_metadata{"tags":["cn"],"image":["https://steemitimages.com/DQmbCtnYnYCbg6Z61staMcKsDd7aasQxUMkx8GKAcDjY8FX/image.png"],"app":"steemit/0.1"}
created2017-07-20 14:06:09
last_update2017-07-20 14:06:09
depth1
children2
last_payout2017-07-27 14:06:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length117
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,080,986
net_rshares3,827,965,384
author_curate_reward""
vote details (1)
@incrediblesnow · 
谢谢你！支持你！
properties (22)
authorincrediblesnow
permlinkre-ace108-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t141750596z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 14:17:54
last_update2017-07-20 14:17:54
depth2
children1
last_payout2017-07-27 14:17:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length8
author_reputation39,931,984,573,642
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,082,145
net_rshares0
@ace108 · 
不客气。
👍  
properties (23)
authorace108
permlinkre-incrediblesnow-re-ace108-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t142952389z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 14:29:48
last_update2017-07-20 14:29:48
depth3
children0
last_payout2017-07-27 14:29:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length4
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,083,376
net_rshares3,923,673,458
author_curate_reward""
vote details (1)
@alexkoshy · 
Great post! Do check out my easy sausage gravy for lazy people like me ,hhahhttps://steemit.com/food/@alexkoshy/easy-to-make-sausage-gravy-for-lazy-people-like-me
properties (22)
authoralexkoshy
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t111637504z
categorycn
json_metadata{"tags":["cn"],"links":["https://steemit.com/food/@alexkoshy/easy-to-make-sausage-gravy-for-lazy-people-like-me"],"app":"steemit/0.1"}
created2017-07-21 11:16:51
last_update2017-07-21 11:16:51
depth1
children0
last_payout2017-07-28 11:16:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length162
author_reputation416,176,224,419
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,184,029
net_rshares0
@allaboutpastries · 
Mmm.  The food looks really delicious. Lucky you. X
properties (22)
authorallaboutpastries
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170722t205737368z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-22 20:57:45
last_update2017-07-22 20:57:45
depth1
children1
last_payout2017-07-29 20:57:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length51
author_reputation4,459,087,612,205
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,347,278
net_rshares0
@ace108 · 
We have good variety of food cheap and more luxury. So, you could say lucky.
Thanks for your comment
properties (22)
authorace108
permlinkre-allaboutpastries-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170723t033919473z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-23 03:39:15
last_update2017-07-23 03:39:15
depth2
children0
last_payout2017-07-30 03:39:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length100
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,374,257
net_rshares0
@allmonitors · 
Nice meal. Congrats to the winner.
properties (22)
authorallmonitors
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t213605929z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 21:36:06
last_update2017-07-20 21:36:06
depth1
children1
last_payout2017-07-27 21:36:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length34
author_reputation1,300,989,614,228,658
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,122,954
net_rshares0
@ace108 · 
Thank you and thanks for stopping to leave a comment.
properties (22)
authorace108
permlinkre-allmonitors-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t223024191z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 22:30:24
last_update2017-07-20 22:30:24
depth2
children0
last_payout2017-07-27 22:30:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length53
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,127,270
net_rshares0
@brianphobos · 
Very good job writing that query!
properties (22)
authorbrianphobos
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-2017720t135622359z
categorycn
json_metadata{"app":"chainbb/0.3","format":"markdown+html","tags":[]}
created2017-07-20 20:56:21
last_update2017-07-20 20:56:21
depth1
children1
last_payout2017-07-27 20:56:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length35
author_reputation174,211,201,252,381
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries
0.
accountchainbb
weight1,500
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,119,712
net_rshares0
@ace108 · 
Thank you. Still starting out much figuring out to be done but the fun begins.
properties (22)
authorace108
permlinkre-brianphobos-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-2017720t135622359z-20170720t222959380z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 22:29:57
last_update2017-07-20 22:29:57
depth2
children0
last_payout2017-07-27 22:29:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length78
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,127,234
net_rshares0
@foodie.warrior · 
Yay I got the correct price for Rainbow Maki!! :)) 

My tori karaage guess was too expensive haha also, the GST is already included in the prices.. :) This was a fun challenge, @ace108! :)
properties (22)
authorfoodie.warrior
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170722t171320351z
categorycn
json_metadata{"tags":["cn"],"users":["ace108"],"app":"steemit/0.1"}
created2017-07-22 17:13:21
last_update2017-07-22 17:13:21
depth1
children1
last_payout2017-07-29 17:13:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length188
author_reputation3,407,069,478,992
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,328,258
net_rshares0
@ace108 · 
Yes, this time round people were quite close too.
properties (22)
authorace108
permlinkre-foodiewarrior-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170723t034048311z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-23 03:40:42
last_update2017-07-23 03:40:42
depth2
children0
last_payout2017-07-30 03:40:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length49
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,374,345
net_rshares0
@gunsmasterrock · 
wow impressive
properties (22)
authorgunsmasterrock
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t184853732z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 19:48:57
last_update2017-07-20 19:48:57
depth1
children1
last_payout2017-07-27 19:48:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length14
author_reputation286,435,025,928
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,114,342
net_rshares0
@ace108 · 
Thank you and thanks for your comment.
properties (22)
authorace108
permlinkre-gunsmasterrock-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t222928310z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 22:29:33
last_update2017-07-20 22:29:33
depth2
children0
last_payout2017-07-27 22:29:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length38
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,127,199
net_rshares0
@happyukgo · 
看起来真好吃呀．
properties (22)
authorhappyukgo
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t151446279z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:14:51
last_update2017-07-20 15:14:51
depth1
children2
last_payout2017-07-27 15:14:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length8
author_reputation462,379,919,024
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,088,148
net_rshares0
@ace108 · 
还好。尤其蛋糕。👍。
谢谢捧场。
properties (22)
authorace108
permlinkre-happyukgo-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t154408353z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:44:09
last_update2017-07-20 15:44:09
depth2
children1
last_payout2017-07-27 15:44:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length16
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,091,182
net_rshares0
@jeffreytong · 
覺得千層蛋糕好吃的話記得要試試lady M 喔 保證一試難忘
properties (22)
authorjeffreytong
permlinkre-ace108-re-happyukgo-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t161828465z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 16:18:30
last_update2017-07-20 16:18:30
depth3
children0
last_payout2017-07-27 16:18:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length30
author_reputation9,330,059,707,684
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,094,736
net_rshares0
@jeremyrana · 
those are pretty greta picture
properties (22)
authorjeremyrana
permlink20170720t141334098z
categorycn
json_metadata{"tags":[],"app":"steemit/0.1"}
created2017-07-20 14:13:33
last_update2017-07-20 14:13:33
depth1
children1
last_payout2017-07-27 14:13:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length30
author_reputation18,772,623,975
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,081,744
net_rshares0
@ace108 · 
Thank you and thanks for your comment
properties (22)
authorace108
permlinkre-jeremyrana-20170720t141334098z-20170720t143205062z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 14:32:00
last_update2017-07-20 14:32:00
depth2
children0
last_payout2017-07-27 14:32:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length37
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,083,612
net_rshares0
@joeyarnoldvn ·
$0.79
Very delicious food. Interesting. Thank you. I'm DOCTOR OATMEAL from the Original Oregon Island. I'm the one & only JOEY ARNOLD of VIETNAM HAWAII. I'm the Ghetto Joe Cool Kid of MAGA.
👍  
properties (23)
authorjoeyarnoldvn
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t064024408z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-21 06:40:24
last_update2017-07-21 06:40:24
depth1
children0
last_payout2017-07-28 06:40:24
cashout_time1969-12-31 23:59:59
total_payout_value0.595 HBD
curator_payout_value0.197 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length183
author_reputation51,968,507,134,439
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,162,510
net_rshares196,638,502,253
author_curate_reward""
vote details (1)
@joythewanderer · (edited)
Nice dinner! 我也要学steemsql
properties (22)
authorjoythewanderer
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t152606441z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:26:12
last_update2017-07-20 15:32:45
depth1
children2
last_payout2017-07-27 15:26:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length25
author_reputation1,916,082,145,948,706
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,089,370
net_rshares0
@ace108 · 
Good especially the cake.  steemsql. 好玩。值得研究。但如果会Python可能更快。下一站吧。
properties (22)
authorace108
permlinkre-joythewanderer-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t154559272z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:45:54
last_update2017-07-20 15:45:54
depth2
children1
last_payout2017-07-27 15:45:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length65
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,091,377
net_rshares0
@joythewanderer · 
I‘ve only learned traditional sql. Seems like it's really useful to learn Python, but I'm really bad at programming. Learned java, C# before, didn't work out.
properties (22)
authorjoythewanderer
permlinkre-ace108-re-joythewanderer-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t160221239z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 16:02:27
last_update2017-07-20 16:02:27
depth3
children0
last_payout2017-07-27 16:02:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length158
author_reputation1,916,082,145,948,706
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,093,089
net_rshares0
@patelincho · 
Congrats to the winner :)
properties (22)
authorpatelincho
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t111800628z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-21 11:29:15
last_update2017-07-21 11:29:15
depth1
children1
last_payout2017-07-28 11:29:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length25
author_reputation52,897,220,193,484
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,184,947
net_rshares0
@ace108 · 
Thank you.
properties (22)
authorace108
permlinkre-patelincho-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t152443820z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-21 15:24:39
last_update2017-07-21 15:24:39
depth2
children0
last_payout2017-07-28 15:24:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length10
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,206,551
net_rshares0
@pepe.maya · 
Matcha cake looks so delicious! :)
properties (22)
authorpepe.maya
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t084531191z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-21 08:45:30
last_update2017-07-21 08:45:30
depth1
children1
last_payout2017-07-28 08:45:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length34
author_reputation30,029,889,404,323
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,171,872
net_rshares0
@ace108 · 
yes. I'm hungry for one now.😎
properties (22)
authorace108
permlinkre-pepemaya-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170721t100116749z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-21 10:01:18
last_update2017-07-21 10:01:18
depth2
children0
last_payout2017-07-28 10:01:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length29
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,178,124
net_rshares0
@soni786 · 
pls follow me. and also like my post you will like this

https://steemit.com/food/@soni786/buffalo-chicken-drumsticks-with-blue-cheese-dip
properties (22)
authorsoni786
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t213135513z
categorycn
json_metadata{"tags":["cn"],"links":["https://steemit.com/food/@soni786/buffalo-chicken-drumsticks-with-blue-cheese-dip"],"app":"steemit/0.1"}
created2017-07-20 21:31:39
last_update2017-07-20 21:31:39
depth1
children1
last_payout2017-07-27 21:31:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length138
author_reputation-20,519,133,465
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,122,638
net_rshares0
@ace108 · 
Thank for reading and leaving a comment. I'll suggest you don't cut and paste your same comment to many posts as it can be considered spam. There is risk of being flag.
properties (22)
authorace108
permlinkre-soni786-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t223320066z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 22:33:15
last_update2017-07-20 22:33:15
depth2
children0
last_payout2017-07-27 22:33:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length168
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,127,481
net_rshares0
@sweetieprincess · 
哇！不错哦！我错过了😝
properties (22)
authorsweetieprincess
permlinkre-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t154524793z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:45:24
last_update2017-07-20 15:45:24
depth1
children1
last_payout2017-07-27 15:45:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length11
author_reputation10,255,421,824,312
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,091,324
net_rshares0
@ace108 · 
哈哈，以后还有机会。
properties (22)
authorace108
permlinkre-sweetieprincess-re-ace108-til-result-of-guess-and-win-price-of-dinner-with-help-of-steemsql-com-or-steemsql-com-by-ace108-20170720t155011776z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-07-20 15:50:06
last_update2017-07-20 15:50:06
depth2
children0
last_payout2017-07-27 15:50:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length10
author_reputation1,239,682,490,593,009
root_title"#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果 (by @ace108)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id9,091,805
net_rshares0
Help/Feedback