![](https://steemitimages.com/DQmYLCqyew8mnT9ZUWRtvuVfmQbFC2uTnqP7V1osNaYsANc/image.png) 首先感谢 @arcange 提供 SteemSQL服务,SteemSQL是一个包含STEEM区块链数据的公共MS-SQL数据库。 First thanks @arcange for providing SteemSQL services, SteemSQL is a public MS-SQL database with all the blockchain data in it. ---- 其实SteemSQL上线之初我马上试用过,但是因为当时第一版只包含一些区块链的transaction数据,用起来还有诸多不便,所以后来SteemData一上线,我就转移战场了,尽管我从来未接触过MongoDB。之后,SteemData一直能满足我的需求,所以就懒得转战回来,但是我依然默默关注这个项目,看着它经过十多次升级变得越来越好,也看着很多STEEMIT的朋友开始使用这个数据库。 今天 @jubi 和我说使用SteemSQL 查询中文标题遇到一些困难,用` WHERE title like '%第一次%'`作为查询条件,查询不到相关数据,但是用英文则可以查询,我答应帮他看看。话说最近他在中文区举办两期***谷哥点名***活动,人气火爆,而***第一次***就是第二期活动的主题。估计太火爆,参与人数众多,单纯地靠人工看帖和整理有些辛苦,于是他想着用程序把整理帖子自动化吧。大家都在成长,这非常好。说到SteemSQL最近,中文区的很多朋友都在用,比如 @ace108, 以及 @joythewanderer, 他们还出过一些向导贴,大家感兴趣可以去翻一翻。 又扯远了,言归正传 # 安装pymssql 我懒得去下桌面软件,还是直接用Python吧 Python下可以使用pyodbc 以及 pymssql啥的,我选择的是pymssql 直接在命令行下直接安装指令 `pip3 install pymssql` 嘎,报一大堆错误, 其它啥的都不认识,我关注的大概三句 >Running setup.py bdist_wheel for pymssql ... error > setup.py: Not using bundled FreeTDS >_mssql.c:266:22: fatal error: sqlfront.h: No such file or directory 去官网查了一下 http://pymssql.org/en/stable/building_and_developing.html 有这样一句 >FreeTDS >= 0.91 including development files. Please research your OS usual software distribution channels, e.g, freetds-dev or freetds-devel packages. 缺啥补啥 `sudo apt-get install freetds-dev` `pip3 install pymssql` 成功! # 执行 SteemSQL 官网地址: http://steemsql.com/ 但是很遗憾上边的链接信息不全,没有Database的信息 或许连上之后,就直接可以查出来,不过我在SteemSQL发布的帖子中找到了连接信息 >Server: sql.steemsql.com User: steemit Password: steemit Database name: DBSteem `import pymssql` `conn = pymssql.connect(host ="sql.steemsql.com",database ="DBSteem",user="steemit",password="steemit")` 在Python里用这个直接连上了,很好。 试着查了一下 `cur = conn.cursor()` `cur.execute("SELECT title FROM Comments WHERE author= 'oflyhigh' and title like '%区块链%'")` 因为我昨天刚写了一篇文章, [使用PHP查询STEEM区块链 / Using PHP to query the STEEM blockchain](https://steemit.com/cn/@oflyhigh/php-steem-using-php-to-query-the-steem-blockchain) 为啥就查不到呢? 然后换个关键词 `cur.execute("SELECT title FROM Comments WHERE author= 'oflyhigh' and title like '%PHP%'")` >('How to install Apache、MYSQL、PHP5 and run a Wordpress website on BananaPi',), ('拖了很久的事情终于完成了,将PHP 5.4 升级到 PHP 5.6',), ('使用PHP查询STEEM区块链 / Using PHP to query the STEEM blockchain',) 查出来的文章包含我的最新文章 # 排查 那么是哪里有问题导致的呢? 我第一个直觉是编码问题 然后,我把链接改成 `conn = pymssql.connect(host ="sql.steemsql.com",database ="DBSteem",user="steemit",password="steemit", charset="utf8")` 结果依旧 又去把FreeTDS的配置文件中加上字符集设置 `sudo find / -name freetds.conf` `sudo vi /etc/freetds/freetds.conf` `sudo vi /usr/share/freetds/freetds.conf` 通通加上: `client charset = UTF-8` 结果依旧 尽管我觉得没必要,但是,又在Python文件中加上 `#-*- coding: utf-8 -*-` 结果依旧 从查出的结果能正常显示来看,数据应该是按UTF-8存储的,那问题出在哪里呢?三把板斧用完了,我的找新招数了。 研究半天,发现个新玩意,就是***在查询内容前加个N*** 详情见 https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql >Prefix Unicode character string constants with the letter N. Without the N prefix, the string is converted to the default code page of the database. This default code page may not recognize certain characters. 把我的查询改成: `cur.execute("SELECT title FROM Comments WHERE author= 'oflyhigh' and title like N'%区块链%'")` 查询结果如下: >我也曾经文青过,18年前写的小诗 《花儿》,学laoyao,咱也放到区块链上 使用PHP查询STEEM区块链 / Using PHP to query the STEEM blockchain 珍惜羽毛 / STEEM区块链忠实的记录你的操作 / 获得共同操作账户的真实操作者 YY 一个基于STEEM区块链的聊天工具 STEEM区块链忠实的记录你的言行&操作 终于可行了 # 再查谷歌点名贴 现在在回头查参加谷歌点名的第二次活动的帖子,主题为`第一次` `cur.execute("SELECT title,created FROM Comments WHERE title like N'%第一次%' and created > '2017/08/01' order by created")` `rows = cur.fetchall()` `for row in rows: print("{}\t{}".format(row[0], row[1]))` 结果如下: >Magic Clay 你第一次用黏土做了什么呢? 2017-08-01 14:13:45 第一次花費從steemit賺到的收益 ! The first time I get the 'real' money from steemit! 2017-08-02 06:11:21 第一次与你们的对话,my first conversation with y'all . 2017-08-03 18:32:51 第一次在steemit cn发文 感谢steemit让我能接触Bitcoin 2017-08-04 17:09:18 第一次人体解剖课上的惊悚事件 2017-08-07 11:30:48 第一次 - 離鄉別井 | “谷哥点名”活动 2017-08-09 07:10:30 相约大美新疆,第一次在第13届全国冬运会现场 Meet the beauty of Xinjiang,first time in China national winter games 2017-08-09 08:31:15 My first encounter with steemit/我与steemit的第一次邂逅 | 谷歌点名 2017-08-09 10:15:33 我人生的N种第一次 2017-08-09 10:31:48 第一次认识这个世界 2017-08-09 10:52:12 第一次 - 英國行山篇 "谷歌点名"活動 Hiking South Downs Way England 2017-08-09 11:00:00 【参加谷哥点名】我在Steemit的第一次发帖 2017-08-09 13:07:39 第一次离开熟悉的地方外出闯荡 2017-08-09 14:12:33 成就人生的第一次 2017-08-09 14:26:54 第一次 // First Time 2017-08-09 17:11:42 人生第一次——不仅有酸甜苦辣,更有悲欢离合 2017-08-09 18:12:18 第一次 - The First Time (Chinese content only but feel free to comment in English if you understsand) - (by @ace108) 2017-08-10 00:34:03 第一次, 细看妈妈的皱纹| “谷哥点名”活动 2017-08-10 01:11:24 爱上第一次--First Exploration 2017-08-10 01:22:15 如何看待你人生中的第一次? 2017-08-10 01:24:48 ?? 老道茶館 ??-請上坐,喝杯茶,說點事;今日話題-第一次 (跨域合作:茶館X谷哥点名) ?? LAODR Tea House ?? 170810 2017-08-10 02:06:03 #隨筆2 第一次 | 谷哥点名 2017-08-10 03:55:33 第一次在星级大酒店吃饭 2017-08-10 04:09:12 第一次绝恋--最后的初恋 The first but also last love. 2017-08-10 04:37:30 第一次品味人生百态 My First Time - Ups and Downs in Life 2017-08-10 05:10:51 第一次 ── 我和我的友生 2017-08-10 05:14:57 第一次拿到在steemit上写作的钱 2017-08-10 05:44:24 领导,今天是我第一次喝酒,可不可以。。。 2017-08-10 06:52:42 第一次去博物馆之中国古代的酒具 The ancient wine cups of the Chinese history 2017-08-10 11:40:54 第一次去油菜花地里玩,种下了心灵里的树 2017-08-10 13:56:00 My first and long leave from my hometown // 第一次離鄉別井 2017-08-10 18:45:03 The first time i made my rose steamed buns 第一次做玫瑰花馒头! 2017-08-10 21:50:18 第一次 — 住在大学宿舍经历 / 谷哥点名活动 | My university life, my first time living in a university hostel 2017-08-10 23:03:06 第一次 - 在第一次家族旅行 - 台中 (內有家族旅行的心得)| The first time - My first family trip - Tai Chung 2017-08-11 01:16:42 很多第一次的第一次 | "谷哥点名" 2017-08-11 01:30:00 第一次“体验”做父母的感觉 / The First Time for Being a "Parent" | 谷歌点名 2017-08-11 04:10:27 第一次来华文区时的情景与华文区如何发展 2017-08-11 06:23:21 第一次注册域名 2017-08-11 08:18:54 第一次,科學研究的第一次/ “谷哥点名”活动 The First time: The Tirst Time for Scientific Research 2017-08-11 09:15:57 第一次去海边 —— “温良恭俭让”的北威尔士海滨小镇兰迪德诺 2017-08-11 09:28:42 第二期“谷哥点名”活動: 第一次 離鄉別井 2017-08-11 09:36:03 我的第一次的虛擬人生 2017-08-11 10:22:18 一天之内的两个第一次 2017-08-11 10:37:51 总算没辜负 @jubi 小友的信任 # 补充 @jubi 用另外一种方法 `WHERE contains(title, '第一次')` 可以查出部分数据 我搜索了一下,contains是基于全文索引进行查询 但结果可能受系统分词方法的影响导致不全 当然,也可能是我不会使用的缘故 😭 ---- 也加俩***第一次***关键字参赛,重在参与 另外,万一中奖呢,哈哈哈
post_id | 9,854,863 |
---|---|
author | oflyhigh |
permlink | steemsql |
category | cn |
json_metadata | "{"format": "markdown", "links": ["http://pymssql.org/en/stable/building_and_developing.html", "http://steemsql.com/", "https://steemit.com/cn/@oflyhigh/php-steem-using-php-to-query-the-steem-blockchain", "https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql"], "app": "steemit/0.1", "tags": ["cn", "steemsql", "cn-programming", "steemdev", "python"], "users": ["arcange", "jubi", "ace108", "joythewanderer"], "image": ["https://steemitimages.com/DQmYLCqyew8mnT9ZUWRtvuVfmQbFC2uTnqP7V1osNaYsANc/image.png"]}" |
created | 2017-08-11 12:05:33 |
last_update | 2017-08-11 12:05:33 |
depth | 0 |
children | 60 |
net_rshares | 84,945,168,565,607 |
last_payout | 2017-08-18 12:05:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 243.240 SBD |
curator_payout_value | 48.130 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 6,451 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
pharesim | 0 | 114,811,711,228 | 0.25% | ||
sandra | 0 | 18,662,230,385 | 9% | ||
abit | 0 | 40,608,806,054,420 | 55% | ||
ihashfury | 0 | 3,197,181,332 | 2.34% | ||
jason | 0 | 18,085,940,460 | 6.21% | ||
jademont | 0 | 151,705,699,170 | 100% | ||
coinbitgold | 0 | 159,793,986,991 | 80% | ||
rok-sivante | 0 | 483,602,124,836 | 100% | ||
wongshiying | 0 | 28,214,065,007 | 100% | ||
mark-waser | 0 | 69,848,028,697 | 33% | ||
geoffrey | 0 | 1,697,316,230,346 | 100% | ||
robrigo | 0 | 97,227,235,453 | 100% | ||
slowwalker | 0 | 1,033,945,552,305 | 10% | ||
livingfree | 0 | 1,625,060,563,253 | 55% | ||
biophil | 0 | 10,680,379,008 | 100% | ||
sephiroth | 0 | 767,074,295,511 | 100% | ||
fundurian | 0 | 28,629,273,348 | 25% | ||
deanliu | 0 | 915,336,388,645 | 100% | ||
rea | 0 | 260,566,364,340 | 25% | ||
joythewanderer | 0 | 205,140,365,912 | 100% | ||
jasonpay1 | 0 | 2,362,506,781 | 100% | ||
lemooljiang | 0 | 268,830,426,273 | 100% | ||
ace108 | 0 | 458,939,022,538 | 25% | ||
lsc9999 | 0 | 125,899,746,239 | 100% | ||
magicmonk | 0 | 35,637,063,766 | 100% | ||
laoyao | 0 | 33,825,421,985 | 100% | ||
myfirst | 0 | 147,623,650,971 | 100% | ||
cryptoninja | 0 | 253,495,710 | 2% | ||
somebody | 0 | 1,399,475,371,171 | 100% | ||
feelapi | 0 | 4,101,605,907 | 60% | ||
midnightoil | 0 | 179,977,338,804 | 100% | ||
btsabc | 0 | 62,479,279,122 | 100% | ||
xiaohui | 0 | 962,763,660,741 | 100% | ||
silentlucidity53 | 0 | 2,427,680,949 | 75% | ||
oflyhigh | 0 | 2,476,105,944,242 | 100% | ||
xiaokongcom | 0 | 16,146,827,426 | 100% | ||
hanshotfirst | 0 | 119,981,997,300 | 5% | ||
rivalhw | 0 | 193,550,708,069 | 100% | ||
nextgen622 | 0 | 1,130,737,659,946 | 100% | ||
chinadaily | 0 | 251,250,426,565 | 100% | ||
helene | 0 | 272,224,729,006 | 100% | ||
dgarsan | 0 | 9,739,136,121 | 100% | ||
ethansteem | 0 | 568,737,611,189 | 100% | ||
sweetsssj | 0 | 3,130,925,622,749 | 10% | ||
bestmz | 0 | 14,507,325,078 | 100% | ||
awkwardawk | 0 | 610,972,334 | 100% | ||
zhijun | 0 | 4,244,576,443 | 100% | ||
englishtchrivy | 0 | 103,328,715,317 | 25% | ||
runridefly | 0 | 5,606,005,371 | 1% | ||
davidjkelley | 0 | 3,297,887,206 | 33% | ||
digital-wisdom | 0 | 29,053,202,643 | 33% | ||
ethical-ai | 0 | 2,531,224,569 | 33% | ||
cornerstone | 0 | 418,742,434,020 | 36% | ||
jwaser | 0 | 17,641,522,856 | 33% | ||
shieha | 0 | 56,087,534,494 | 33% | ||
profitgenerator | 0 | 13,714,996,077 | 100% | ||
bwaser | 0 | 4,139,734,184 | 33% | ||
justyy | 0 | 0 | 0% | ||
ellepdub | 0 | 6,433,942,524 | 33% | ||
arama | 0 | 630,380,975,810 | 10% | ||
herpetologyguy | 0 | 134,473,165,303 | 33% | ||
morgan.waser | 0 | 7,311,536,468 | 33% | ||
handyman | 0 | 3,277,658,711 | 33% | ||
strong-ai | 0 | 8,212,404,226 | 33% | ||
siniceku | 0 | 3,431,500,924 | 100% | ||
stacee | 0 | 54,765,571,675 | 100% | ||
luneknight | 0 | 476,980,589 | 100% | ||
steemtruth | 0 | 37,692,414,850 | 10% | ||
lalala | 0 | 38,815,688,647 | 100% | ||
black-eye | 0 | 67,709,139 | 100% | ||
themeanbean | 0 | 45,853,445,119 | 100% | ||
amat | 0 | 214,342,004 | 50% | ||
jmehta | 0 | 3,502,452,714 | 100% | ||
joseluismejia | 0 | 61,491,858 | 100% | ||
kolasam | 0 | 140,428,827 | 100% | ||
devilwsy | 0 | 2,473,701,010 | 100% | ||
janiceting | 0 | 2,471,403,093 | 100% | ||
ozymandias | 0 | 2,335,116,538 | 100% | ||
lydiachan | 0 | 60,526,166,083 | 100% | ||
technoprogressiv | 0 | 7,902,462,307 | 33% | ||
blacktranquility | 0 | 21,572,747,260 | 100% | ||
vcelier | 0 | 2,651,391,155,447 | 51% | ||
guytremat | 0 | 30,826,663,325 | 100% | ||
dragon40 | 0 | 3,418,894,512 | 10% | ||
lazariko12 | 0 | 18,514,304,580 | 100% | ||
blackbunny | 0 | 21,358,210,814 | 100% | ||
firesteem | 0 | 2,499,614,316 | 100% | ||
jubi | 0 | 8,228,549,022 | 100% | ||
countzero | 0 | 4,053,918,618 | 100% | ||
steemav | 0 | 1,551,960,953 | 100% | ||
ejemai | 0 | 3,342,177,493 | 100% | ||
chessmasterhex | 0 | 2,495,392,320 | 100% | ||
lingfei | 0 | 58,087,964,487 | 100% | ||
gavvett | 0 | 1,165,155,749 | 100% | ||
yyyy | 0 | 13,652,934,388 | 100% | ||
almustaghfiri | 0 | 1,364,632,223 | 100% | ||
azfix | 0 | 50,182,765,001 | 100% | ||
cybertiger | 0 | 1,008,586,255 | 100% | ||
money-alchemist | 0 | 2,147,799,212 | 100% | ||
lawrenceho84 | 0 | 28,251,444,048 | 4% | ||
trafalgar | 0 | 1,895,910,364,339 | 9% | ||
elevator09 | 0 | 5,404,328,284 | 25% | ||
aomura | 0 | 200,892,623,950 | 100% | ||
aismor | 0 | 711,548,938 | 100% | ||
hammadakhtar | 0 | 958,399,492 | 10% | ||
kingofdew | 0 | 45,339,383,158 | 100% | ||
coocoocachoo | 0 | 20,704,630,894 | 100% | ||
andy2007 | 0 | 649,319,985 | 100% | ||
htliao | 0 | 3,408,983,218,101 | 25% | ||
gordonovich | 0 | 1,041,324,335 | 5% | ||
maros | 0 | 599,832,639 | 100% | ||
emcvay | 0 | 1,249,698,371 | 10% | ||
tungie | 0 | 9,882,861,192 | 90% | ||
manuel78 | 0 | 119,265,374 | 1% | ||
anubisthegaylord | 0 | 3,583,938,673 | 100% | ||
mandagoi | 0 | 7,958,526,330 | 10% | ||
ribalinux | 0 | 5,588,685,248 | 25% | ||
crisgojar | 0 | 16,639,360,568 | 100% | ||
nerdylab | 0 | 2,401,016,539 | 100% | ||
jerrybanfield | 0 | 187,457,005,854 | 10% | ||
ojaber | 0 | 12,911,887,002 | 100% | ||
youknow212012 | 0 | 12,928,665,875 | 100% | ||
wylo | 0 | 581,735,663 | 100% | ||
followbtcnews | 0 | 24,546,581,562 | 20% | ||
omwith | 0 | 33,072,164,873 | 100% | ||
sneakgeekz | 0 | 46,108,377,299 | 17% | ||
jkkim | 0 | 31,145,695,522 | 10% | ||
flauschi | 0 | 280,430,596 | 100% | ||
xenitron | 0 | 42,587,182,504 | 100% | ||
jezequiel | 0 | 3,650,924,153 | 100% | ||
pakyeechan | 0 | 17,900,309,680 | 100% | ||
kitcat | 0 | 31,217,227,504 | 60% | ||
happychau123 | 0 | 6,016,504,415 | 100% | ||
victorier | 0 | 8,518,862,920 | 40% | ||
linuslee0216 | 0 | 7,521,292,529,088 | 40% | ||
revelim | 0 | 7,320,396,130 | 30% | ||
arkoko | 0 | 2,000,155,074 | 100% | ||
cryptohustler | 0 | 17,670,391,976 | 100% | ||
fatamorgan | 0 | 8,479,807,082 | 100% | ||
benderisgreat | 0 | 466,791,590 | 100% | ||
dmb168 | 0 | 597,836,800 | 100% | ||
wilkinshui | 0 | 34,857,402,328 | 100% | ||
zulkabar | 0 | 499,070,816 | 100% | ||
exec | 0 | 85,498,682,681 | 100% | ||
eval | 0 | 865,207,484 | 100% | ||
davidk | 0 | 2,824,101,233 | 100% | ||
michaelwilshaw | 0 | 3,723,232,198 | 100% | ||
izar | 0 | 1,622,894,452 | 100% | ||
tsinrong | 0 | 785,786,376 | 100% | ||
chris77d | 0 | 8,238,523,874 | 100% | ||
aaronli | 0 | 6,172,614,353 | 100% | ||
siddm96 | 0 | 603,136,079 | 100% | ||
crimsonclad | 0 | 1,010,419,724 | 4.4% | ||
nationalpark | 0 | 20,601,352,539 | 100% | ||
janny | 0 | 1,684,024,794 | 100% | ||
shenchensucc | 0 | 13,923,197,673 | 100% | ||
krischy | 0 | 17,333,416,035 | 100% | ||
prateek547 | 0 | 1,437,519,242 | 100% | ||
suavimani | 0 | 226,124,800 | 100% | ||
biuiam | 0 | 2,682,433,869 | 100% | ||
samuelsunday | 0 | 86,387,897 | 100% | ||
asterix87 | 0 | 14,043,997,038 | 100% | ||
crypsis | 0 | 283,601,513 | 100% | ||
dheerajdj | 0 | 15,866,767,019 | 100% | ||
completelyanon | 0 | 4,165,650,011 | 1% | ||
wahyusaputra | 0 | 1,171,467,809 | 100% | ||
abetterworld | 0 | 1,370,690,711 | 100% | ||
bucho | 0 | 14,553,222,082 | 100% | ||
hobby-club | 0 | 2,547,705,859 | 100% | ||
mabre | 0 | 2,515,424,114 | 10% | ||
ldauch | 0 | 7,146,062,957 | 100% | ||
zeidlitwhips | 0 | 595,914,561 | 25.07% | ||
stevepaul | 0 | 779,688,256 | 100% | ||
sharoon | 0 | 154,576,390 | 100% | ||
ikenna | 0 | 1,936,424,248 | 100% | ||
okdubai | 0 | 615,190,350 | 100% | ||
devilcat | 0 | 291,174,400 | 100% | ||
lilcandyboss | 0 | 408,883,200 | 100% | ||
marcuswilliams | 0 | 83,668,649 | 50% | ||
sweeti | 0 | 13,310,409,029 | 10% | ||
vargapauline | 0 | 1,294,754,791 | 100% | ||
travelmuse | 0 | 7,960,945,463 | 100% | ||
mrpointp | 0 | 11,609,511,889 | 38% | ||
kolex | 0 | 458,912,754 | 100% | ||
sebastianjackson | 0 | 305,022,100 | 50% | ||
sanzo | 0 | 474,027,583 | 100% | ||
themystic | 0 | 15,234,054,680 | 100% | ||
kingjan | 0 | 3,485,597,558 | 100% | ||
yourahea | 0 | 3,252,267,867 | 100% | ||
e-bass | 0 | 787,594,684 | 100% | ||
swssmarketing | 0 | 1,978,006,485 | 5% | ||
freetosteemdream | 0 | 152,390,048 | 100% | ||
doraemon | 0 | 579,251,200 | 100% | ||
beautifulbella | 0 | 4,843,330,004 | 100% | ||
davaowhenyo | 0 | 616,422,400 | 100% | ||
allenshayzar | 0 | 616,422,400 | 100% | ||
travelgirl | 0 | 6,068,052,295 | 51% | ||
raku | 0 | 155,548,525 | 100% | ||
jukas | 0 | 362,587,631 | 66% | ||
resteeming | 0 | 586,570,491 | 100% | ||
ravenousappetite | 0 | 619,520,000 | 100% | ||
adnanshakeel | 0 | 91,189,868 | 14.35% | ||
kyawhlaing | 0 | 3,712,223,449 | 100% | ||
dsian | 0 | 607,129,600 | 100% | ||
simonsayz | 0 | 7,125,345,393 | 100% | ||
falcao12 | 0 | 2,267,223,966 | 100% | ||
wanderwithtwo | 0 | 1,477,997,320 | 100% | ||
mamamyanmar | 0 | 255,304,147 | 62.97% | ||
shirlam | 0 | 634,215,090 | 100% | ||
ayuwandira | 0 | 2,666,773,561 | 100% | ||
auntigormint | 0 | 1,423,976,998 | 100% | ||
nickwalshblog | 0 | 371,022,994 | 100% | ||
isabelpena | 0 | 710,248,073 | 100% | ||
the3metrewrap | 0 | 3,930,724,781 | 100% | ||
mhelows | 0 | 1,206,910,866 | 100% | ||
twinkledrop | 0 | 23,322,485,440 | 100% | ||
cheonillhwan | 0 | 352,976,646 | 100% | ||
aaronaugustine | 0 | 229,695,996 | 100% | ||
munzil | 0 | 1,819,847,608 | 80% | ||
yusrizal08 | 0 | 947,721,261 | 100% | ||
awinyaksteemit | 0 | 1,018,703,306 | 100% | ||
nicolemoker | 0 | 5,973,398,071,651 | 30% | ||
varungohil | 0 | 387,225,810 | 100% | ||
negojobs | 0 | 585,641,546 | 100% | ||
azisjesika | 0 | 351,581,253 | 100% | ||
davidzack | 0 | 418,371,283 | 100% | ||
good-joinned | 0 | 405,395,730 | 100% | ||
arvindsingh | 0 | 337,363,461 | 100% | ||
shasol | 0 | 591,476,023 | 100% | ||
aek081969 | 0 | 59,415,988 | 100% | ||
daniel007 | 0 | 171,536,656 | 100% | ||
na722 | 0 | 325,273,536 | 100% | ||
dhabal | 0 | 267,745,979 | 100% | ||
raviraj4you | 0 | 956,541,061 | 100% | ||
bukhairidin | 0 | 175,639,777 | 100% | ||
sweethoney | 0 | 633,276,910 | 100% | ||
bukharisulaiman | 0 | 742,590,101 | 100% | ||
cryptousage | 0 | 5,713,555,730 | 100% | ||
glennolua | 0 | 322,877,336 | 100% | ||
rupaibabu | 0 | 223,420,457 | 100% | ||
duekie | 0 | 493,792,512 | 100% | ||
sem89 | 0 | 211,882,975 | 100% | ||
idx | 0 | 10,953,564,746 | 55% | ||
kanokwan | 0 | 350,769,464 | 41.74% | ||
techtek | 0 | 1,289,650,757 | 100% | ||
taufik | 0 | 85,476,863 | 100% | ||
rmaxhuni | 0 | 165,352,136 | 100% | ||
allabout | 0 | 1,216,380,689 | 66% | ||
saifulyukache | 0 | 585,446,400 | 100% | ||
gladiator4war | 0 | 229,543,196 | 100% | ||
siriusden | 0 | 264,401,480 | 100% | ||
swaticute | 0 | 1,254,129,344 | 100% | ||
malakah | 0 | 359,280,931 | 100% | ||
ahmedkedd | 0 | 446,054,400 | 100% | ||
kangnajiang | 0 | 533,501,744 | 100% | ||
exprmnt | 0 | 1,286,856,502 | 100% | ||
marier | 0 | 619,520,000 | 100% | ||
roy92 | 0 | 1,505,423,363 | 100% | ||
shakibsarker | 0 | 531,328,910 | 100% | ||
rooneey | 0 | 668,951,284 | 100% | ||
mrs.ginger | 0 | 619,520,000 | 100% | ||
elconserje | 0 | 619,520,000 | 100% | ||
sylvia1997 | 0 | 4,527,534,138 | 100% | ||
herlife | 0 | 2,115,238,201 | 100% | ||
minimalpris | 0 | 506,293,419 | 100% | ||
azis | 0 | 285,372,800 | 100% | ||
candiceji | 0 | 482,689,397 | 100% | ||
katkar | 0 | 603,273,475 | 100% | ||
hopsken | 0 | 927,071,352 | 100% | ||
slava7450745 | 0 | 158,261,918 | 100% | ||
porlacarretera | 0 | 667,911,551 | 100% | ||
attilaloe | 0 | 109,028,776 | 100% | ||
gellany | 0 | 78,452,554 | 100% | ||
tvb | 0 | 339,171,997 | 100% | ||
beautypics | 0 | 35,417,374,771 | 13% | ||
resteem.bot | 0 | 71,579,777 | 100% | ||
xto | 0 | 607,129,600 | 100% | ||
jrobi | 0 | 233,524,342 | 40% | ||
skenan | 0 | 2,418,656,360 | 100% | ||
rogermarx | 0 | 612,941,150 | 100% | ||
azka-amillia | 0 | 394,805,020 | 100% | ||
davidconstantine | 0 | 2,499,948,811 | 100% | ||
nigeldarren | 0 | 582,032,428 | 100% | ||
rizkirz | 0 | 585,446,400 | 100% | ||
sharif99 | 0 | 489,420,800 | 100% | ||
upasos | 0 | 553,664,624 | 100% | ||
bakingsoda | 0 | 545,831,718 | 100% | ||
tuongvile | 0 | 610,227,200 | 100% | ||
free999enigma | 0 | 90,842,654 | 100% | ||
vetmed | 0 | 589,075,493 | 100% | ||
batraiselis | 0 | 393,447,637 | 66% | ||
solomonsojay | 0 | 841,884,510 | 100% | ||
lamorte | 0 | 384,921,681 | 100% | ||
syahrulrahmat | 0 | 211,553,933 | 100% | ||
chandrarai | 0 | 353,644,182 | 100% | ||
cristian-mesa | 0 | 454,510,267 | 100% | ||
ernestoperez | 0 | 486,323,200 | 100% | ||
boshler | 0 | 591,641,600 | 100% | ||
natasha79 | 0 | 620,345,808 | 100% | ||
steemitlietuva | 0 | 940,530,121 | 90% | ||
ridwan-kamil | 0 | 176,563,200 | 100% | ||
writer1 | 0 | 98,908,157 | 100% | ||
vipnata | 0 | 585,446,400 | 100% | ||
brianhphotos | 0 | 2,473,252,737 | 100% | ||
freedom-fighter | 0 | 619,520,000 | 100% | ||
artax89 | 0 | 580,325,133 | 100% | ||
kunrishartanto | 0 | 319,178,698 | 100% | ||
naresh1 | 0 | 1,079,404,236 | 100% | ||
ramiashqar | 0 | 121,868,202 | 100% | ||
steemitcu | 0 | 690,584,839 | 66% | ||
gr3g0r | 0 | 87,048,496 | 100% | ||
biltu1995 | 0 | 446,848,841 | 100% | ||
denisreach | 0 | 667,371,254 | 100% | ||
mousum | 0 | 464,258,125 | 100% | ||
cryptoron | 0 | 858,877,531 | 100% | ||
kakaobank | 0 | 1,160,645,289 | 100% | ||
sujitkhanal | 0 | 934,319,437 | 100% | ||
pratibha | 0 | 1,085,203,287 | 100% | ||
astarte89 | 0 | 847,270,887 | 100% | ||
syedanas | 0 | 516,487,004 | 100% | ||
allamo121 | 0 | 1,038,775,790 | 100% | ||
jajabormanus | 0 | 98,654,665 | 100% | ||
benjy87 | 0 | 905,301,580 | 100% | ||
masterycon | 0 | 1,096,807,666 | 100% | ||
marylewis | 0 | 1,079,397,842 | 100% | ||
danee94 | 0 | 1,079,397,802 | 100% | ||
parkers | 0 | 974,939,936 | 100% | ||
douglasfranco | 0 | 516,486,035 | 100% | ||
hiltonrp | 0 | 980,743,109 | 100% | ||
medas | 0 | 1,096,807,373 | 100% | ||
zulkarnaini58 | 0 | 1,108,413,730 | 100% | ||
contenidos | 0 | 0 | 100% |
很实用哎
post_id | 9,855,083 |
---|---|
author | sylvia1997 |
permlink | re-oflyhigh-steemsql-20170811t120919271z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:09:15 |
last_update | 2017-08-11 12:09:15 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:09:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 4 |
author_reputation | 12,783,997,194,630 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
谢谢夸奖
post_id | 9,855,248 |
---|---|
author | oflyhigh |
permlink | re-sylvia1997-re-oflyhigh-steemsql-20170811t121150305z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:11:57 |
last_update | 2017-08-11 12:11:57 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:11:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 4 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
我看到很多第一次的標題!支持支持!
post_id | 9,855,097 |
---|---|
author | nicolemoker |
permlink | re-oflyhigh-steemsql-20170811t120928432z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:09:27 |
last_update | 2017-08-11 12:09:27 |
depth | 1 |
children | 3 |
net_rshares | 0 |
last_payout | 2017-08-18 12:09:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 17 |
author_reputation | 38,904,514,499,428 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
谢谢美女支持 加了好多第一次,哈哈,算作弊不?
post_id | 9,855,292 |
---|---|
author | oflyhigh |
permlink | re-nicolemoker-re-oflyhigh-steemsql-20170811t121225881z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:12:33 |
last_update | 2017-08-11 12:12:33 |
depth | 2 |
children | 2 |
net_rshares | 20,431,916,559 |
last_payout | 2017-08-18 12:12:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.052 SBD |
curator_payout_value | 0.017 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 23 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
magicmonk | 0 | 20,431,916,559 | 100% |
還是你利害,什麼問題也能解決!
post_id | 9,855,806 |
---|---|
author | nicolemoker |
permlink | re-oflyhigh-re-nicolemoker-re-oflyhigh-steemsql-20170811t122007581z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:20:09 |
last_update | 2017-08-11 12:20:09 |
depth | 3 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:20:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 15 |
author_reputation | 38,904,514,499,428 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
谢谢O哥,我也试着查过中文关键字,但是怎么都出不了数据 原来是少了个N,我试过用%%代替一个%,也试过%%ch,都出不来,谢谢解答疑惑。
post_id | 9,855,120 |
---|---|
author | joythewanderer |
permlink | re-oflyhigh-steemsql-20170811t120927225z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:09:45 |
last_update | 2017-08-11 12:09:45 |
depth | 1 |
children | 3 |
net_rshares | 19,956,755,709 |
last_payout | 2017-08-18 12:09:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.051 SBD |
curator_payout_value | 0.015 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 68 |
author_reputation | 812,830,516,164,099 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
magicmonk | 0 | 19,956,755,709 | 100% |
其实和字段的存储方式有关 我查了一下title字段存储成nvarchar 加个N前缀,就强制使用UNICODE编码,而不是转换成数据库默认编码 具体细节我也不太懂,好多年没怎么用了 我第一直觉就是编码问题,但是也是试了好几种办法才找到当前方案的
post_id | 9,855,614 |
---|---|
author | oflyhigh |
permlink | re-joythewanderer-re-oflyhigh-steemsql-20170811t121727072z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:17:33 |
last_update | 2017-08-11 12:17:33 |
depth | 2 |
children | 2 |
net_rshares | 10,520,051,793 |
last_payout | 2017-08-18 12:17:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.026 SBD |
curator_payout_value | 0.007 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 123 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
joythewanderer | 0 | 10,520,051,793 | 5% |
👍 真是学习了!中文关键字真是大难题。
post_id | 9,858,791 |
---|---|
author | joythewanderer |
permlink | re-oflyhigh-re-joythewanderer-re-oflyhigh-steemsql-20170811t125552246z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:56:09 |
last_update | 2017-08-11 12:56:09 |
depth | 3 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:56:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 19 |
author_reputation | 812,830,516,164,099 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
这样就方便多了,哈哈,还是o哥厉害。 也可以用来查询别的数据。
post_id | 9,855,163 |
---|---|
author | jubi |
permlink | re-oflyhigh-steemsql-20170811t120939411z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:10:24 |
last_update | 2017-08-11 12:10:24 |
depth | 1 |
children | 3 |
net_rshares | 0 |
last_payout | 2017-08-18 12:10:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 31 |
author_reputation | 81,283,051,616,409 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
大家都很厉害的啦 我也是现学现卖
post_id | 9,855,646 |
---|---|
author | oflyhigh |
permlink | re-jubi-re-oflyhigh-steemsql-20170811t121754364z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:18:00 |
last_update | 2017-08-11 12:18:00 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:18:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 16 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
@jubi 。。。o哥帮你那么大的忙是不是应该打赏一下:) 现在您也可以打赏STEEMIT作者 https://steemit.com/cn/@beautifulbella/steemit-now-you-can-tip-steemit-author
post_id | 9,857,304 |
---|---|
author | beautifulbella |
permlink | re-jubi-re-oflyhigh-steemsql-20170811t123825403z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "users": ["jubi"], "links": ["https://steemit.com/cn/@beautifulbella/steemit-now-you-can-tip-steemit-author"], "tags": ["cn"]}" |
created | 2017-08-11 12:38:45 |
last_update | 2017-08-11 12:38:45 |
depth | 2 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:38:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 126 |
author_reputation | 1,876,434,171,956 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
得先去研究下你发的这个打赏机器人先。
post_id | 9,857,693 |
---|---|
author | jubi |
permlink | re-beautifulbella-re-jubi-re-oflyhigh-steemsql-20170811t124240704z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:43:24 |
last_update | 2017-08-11 12:43:24 |
depth | 3 |
children | 0 |
net_rshares | 4,719,142,056 |
last_payout | 2017-08-18 12:43:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 18 |
author_reputation | 81,283,051,616,409 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
beautifulbella | 0 | 4,719,142,056 | 100% |
Your voting will force your voice to give me strength. thanks.
post_id | 9,855,639 | ||||||
---|---|---|---|---|---|---|---|
author | good-joinned | ||||||
permlink | re-oflyhigh-2017811t191750478z | ||||||
category | cn | ||||||
json_metadata | "{"app": "esteem/1.4.5", "format": "markdown+html", "community": "esteem", "tags": "cn"}" | ||||||
created | 2017-08-11 12:17:54 | ||||||
last_update | 2017-08-11 12:17:54 | ||||||
depth | 1 | ||||||
children | 0 | ||||||
net_rshares | 0 | ||||||
last_payout | 2017-08-18 12:17:54 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.000 SBD | ||||||
curator_payout_value | 0.000 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 62 | ||||||
author_reputation | 724,435,960,074 | ||||||
root_title | 第一次使用STEEMSQL查询谷哥点名数据 | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||
percent_steem_dollars | 10,000 |
Thank you for sharing with us! I hope you enjoy the upvote!
post_id | 9,855,851 |
---|---|
author | completelyanon |
permlink | completelyanon-re-oflyhighsteemsql |
category | cn |
json_metadata | {} |
created | 2017-08-11 12:20:42 |
last_update | 2017-08-11 12:20:42 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:20:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 59 |
author_reputation | 3,202,989,799,343 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
赞,收藏先。
post_id | 9,856,156 |
---|---|
author | justyy |
permlink | re-oflyhigh-steemsql-20170811t122456989z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:24:57 |
last_update | 2017-08-11 12:24:57 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:24:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 6 |
author_reputation | 2,057,469,156,047,835 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
谢谢
post_id | 9,856,712 |
---|---|
author | oflyhigh |
permlink | re-justyy-re-oflyhigh-steemsql-20170811t123141542z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:31:48 |
last_update | 2017-08-11 12:31:48 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:31:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 2 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
O 哥哥 這個很實用啊 👍
post_id | 9,856,388 |
---|---|
author | travelgirl |
permlink | re-oflyhigh-steemsql-20170811t122751451z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:27:54 |
last_update | 2017-08-11 12:27:54 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:27:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 13 |
author_reputation | 653,966,580,970,956 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
谢谢夸奖
post_id | 9,856,749 |
---|---|
author | oflyhigh |
permlink | re-travelgirl-re-oflyhigh-steemsql-20170811t123205238z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:32:12 |
last_update | 2017-08-11 12:32:12 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:32:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 4 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
万一中奖了呢……
post_id | 9,856,655 |
---|---|
author | zhijun |
permlink | re-oflyhigh-steemsql-20170811t123110409z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:31:12 |
last_update | 2017-08-11 12:31:12 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:31:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 8 |
author_reputation | 4,501,252,062,061 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
😀
post_id | 9,857,347 |
---|---|
author | oflyhigh |
permlink | re-zhijun-re-oflyhigh-steemsql-20170811t123907663z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:39:12 |
last_update | 2017-08-11 12:39:12 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:39:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 1 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
O婶威武啊
post_id | 9,856,720 |
---|---|
author | lemooljiang |
permlink | re-oflyhigh-steemsql-20170811t123140157z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:31:51 |
last_update | 2017-08-11 12:31:51 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 12:31:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 5 |
author_reputation | 263,700,595,848,611 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
诗王威武!
post_id | 9,857,377 |
---|---|
author | oflyhigh |
permlink | re-lemooljiang-re-oflyhigh-steemsql-20170811t123928590z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:39:33 |
last_update | 2017-08-11 12:39:33 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:39:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 5 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
嘩嘩很強!我的第一次現在排18,看來沒有机会得獎了🙈 會否越新的文章會較容易排在前面?
post_id | 9,857,217 |
---|---|
author | aaronli |
permlink | re-oflyhigh-steemsql-20170811t123734240z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:37:33 |
last_update | 2017-08-11 12:37:33 |
depth | 1 |
children | 4 |
net_rshares | 0 |
last_payout | 2017-08-18 12:37:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 43 |
author_reputation | 226,174,919,515,327 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
我文章中的排序吗?是按时间排序的
post_id | 9,857,407 |
---|---|
author | oflyhigh |
permlink | re-aaronli-re-oflyhigh-steemsql-20170811t123949387z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:39:54 |
last_update | 2017-08-11 12:39:54 |
depth | 2 |
children | 3 |
net_rshares | 0 |
last_payout | 2017-08-18 12:39:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 16 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
那即是我还有机會中獎了🙈🙈🙈🙈
post_id | 9,857,621 |
---|---|
author | aaronli |
permlink | re-oflyhigh-re-aaronli-re-oflyhigh-steemsql-20170811t124226794z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:42:27 |
last_update | 2017-08-11 12:42:27 |
depth | 3 |
children | 2 |
net_rshares | 0 |
last_payout | 2017-08-18 12:42:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 15 |
author_reputation | 226,174,919,515,327 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
我也今天剛剛参加了,沒有看到我的 lol'
post_id | 9,857,665 |
---|---|
author | krischy |
permlink | re-oflyhigh-steemsql-20170811t124303375z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:43:03 |
last_update | 2017-08-11 12:43:03 |
depth | 1 |
children | 6 |
net_rshares | 0 |
last_payout | 2017-08-18 12:43:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 21 |
author_reputation | 35,663,357,100,120 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
啊 第二期“谷哥点名”活動: 第一次 離鄉別井 2017-08-11 09:36:03 @krischy 冤枉好人,该当何罪? 😭
post_id | 9,859,670 |
---|---|
author | oflyhigh |
permlink | re-krischy-re-oflyhigh-steemsql-20170811t130707173z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "users": ["krischy"], "tags": ["cn"]}" |
created | 2017-08-11 13:07:12 |
last_update | 2017-08-11 13:07:12 |
depth | 2 |
children | 5 |
net_rshares | 20,431,916,559 |
last_payout | 2017-08-18 13:07:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.052 SBD |
curator_payout_value | 0.017 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 66 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
magicmonk | 0 | 20,431,916,559 | 100% |
是小妹沒看清楚 , 我來跪玻璃 😭 😭
post_id | 9,859,978 |
---|---|
author | krischy |
permlink | re-oflyhigh-re-krischy-re-oflyhigh-steemsql-20170811t131115177z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 13:11:15 |
last_update | 2017-08-11 13:11:15 |
depth | 3 |
children | 4 |
net_rshares | 0 |
last_payout | 2017-08-18 13:11:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 19 |
author_reputation | 35,663,357,100,120 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Thank you for sharing.
post_id | 9,857,772 |
---|---|
author | cryptousage |
permlink | re-oflyhigh-steemsql-20170811t124427555z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:44:27 |
last_update | 2017-08-11 12:44:27 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:44:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 22 |
author_reputation | 38,508,407,201 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Hii @oflyhigh successful greetings Nice to meet you #introduce my name @ firzee0717, I come from #aceh Sumatra. Welcome to #steemit for those of you who want to succeed here, I also want the same thing. I'm also new here #Steem is still a lot to learn from seniors. Nice to meet you all !! Please help to promote me And Please for others follow and Upvote My account @ firzee0717 I love you all
post_id | 9,857,848 |
---|---|
author | firzee0717 |
permlink | re-oflyhigh-steemsql-20170811t124516254z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "users": ["oflyhigh"], "tags": ["introduce", "aceh", "steemit", "steem", "cn"]}" |
created | 2017-08-11 12:45:15 |
last_update | 2017-08-11 12:45:15 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 12:45:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 396 |
author_reputation | 2,435,940,447 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
English translation please?
post_id | 9,858,982 |
---|---|
author | x-p |
permlink | re-oflyhigh-steemsql-20170811t125827394z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 12:58:33 |
last_update | 2017-08-11 12:58:33 |
depth | 1 |
children | 1 |
net_rshares | 16,496,068,655 |
last_payout | 2017-08-18 12:58:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.053 SBD |
curator_payout_value | 0.002 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 27 |
author_reputation | 344,085,733,826 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
x-p | 0 | 9,337,863,867 | 100% | ||
digitalharmony | 0 | 5,814,818,583 | 100% | ||
techtek | 0 | 1,343,386,205 | 100% |
Yes please :)
post_id | 9,873,755 |
---|---|
author | techtek |
permlink | re-x-p-re-oflyhigh-steemsql-20170811t155109672z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 15:51:27 |
last_update | 2017-08-11 15:51:27 |
depth | 2 |
children | 0 |
net_rshares | 1,321,892,026 |
last_payout | 2017-08-18 15:51:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 13 |
author_reputation | 27,261,864,541,956 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
techtek | 0 | 1,321,892,026 | 100% |
Thanks, very informative, I am following you now @oflyhigh
post_id | 9,861,232 |
---|---|
author | simonsayz |
permlink | re-oflyhigh-steemsql-20170811t132724257z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "users": ["oflyhigh"], "tags": ["cn"]}" |
created | 2017-08-11 13:27:24 |
last_update | 2017-08-11 13:27:24 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 13:27:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 58 |
author_reputation | 974,740,225,556 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
建议一下你加个 WAIT (NOLOCK) 比如: <pre><code>SELECT author, title,created FROM Comments <b>WAIT (NOLOCK) </b> WHERE title like N'%第一次%' and created > '2017/08/01' order by created</code></pre> 也是昨天找furion问steemsql缺数据的问题他告诉我的。 这样不会把数据库锁住。我用Oracle没这必要但MS SQL Server 好像这比较好。 呵呵。。。我也来看个究竟。 哦,我在中间。:-) ![](https://steemitimages.com/DQmShcpWHSWEPhKWQdXZtPgMD6mF1cHX4vWUfGcSDyk8ETr/image.png)
post_id | 9,862,286 |
---|---|
author | ace108 |
permlink | re-oflyhigh-steemsql-20170811t134055946z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "image": ["https://steemitimages.com/DQmShcpWHSWEPhKWQdXZtPgMD6mF1cHX4vWUfGcSDyk8ETr/image.png"], "tags": ["cn"]}" |
created | 2017-08-11 13:41:00 |
last_update | 2017-08-11 13:41:00 |
depth | 1 |
children | 4 |
net_rshares | 594,594,474,077 |
last_payout | 2017-08-18 13:41:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 1.851 SBD |
curator_payout_value | 0.177 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 387 |
author_reputation | 585,838,322,788,458 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
oflyhigh | 0 | 594,265,426,618 | 25% | ||
tvb | 0 | 329,047,459 | 100% |
感谢专家指点 MSSQL我很少用,除了以前做项目的时候接触过一两次 以后和你们多学习 另外, steemsql少数据你找furion干啥,他是steemdata的 😀
post_id | 9,863,211 |
---|---|
author | oflyhigh |
permlink | re-ace108-re-oflyhigh-steemsql-20170811t135123710z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 13:51:30 |
last_update | 2017-08-11 13:51:30 |
depth | 2 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-18 13:51:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 84 |
author_reputation | 1,148,153,621,496,884 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
哦错了,是 arcange. 我也找 furion 问sbds.那里数据也好像过时。 MSSQL 我也刚开始用。不是专家。 :-) Oracle 的就用过很多年了。
post_id | 9,863,967 |
---|---|
author | ace108 |
permlink | re-oflyhigh-re-ace108-re-oflyhigh-steemsql-20170811t135845907z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 13:58:45 |
last_update | 2017-08-11 13:58:45 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 13:58:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 82 |
author_reputation | 585,838,322,788,458 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
WAIT (NOLOCK) 顺便查了一下 NOLOCK 懂了个大概,感谢大神!
post_id | 10,056,136 |
---|---|
author | tvb |
permlink | re-ace108-re-oflyhigh-steemsql-20170813t213808884z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-13 21:38:15 |
last_update | 2017-08-13 21:38:15 |
depth | 2 |
children | 1 |
net_rshares | 0 |
last_payout | 2017-08-20 21:38:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 40 |
author_reputation | 35,846,309,024,528 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
别客气。我非大神。 也是最近得指点上网找了下才知。 :-)
post_id | 10,059,188 |
---|---|
author | ace108 |
permlink | re-tvb-re-ace108-re-oflyhigh-steemsql-20170813t223250129z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-13 22:32:54 |
last_update | 2017-08-13 22:32:54 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-20 22:32:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 29 |
author_reputation | 585,838,322,788,458 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
hi @oflyhigh...... A very useful post for all steemit users around the world, hoping those who read it can post every piece of their writing beautifully by using such a good basic procedure, organized and nice to read, how not to. Using the clues you share can give birth to works that look very unusual. Continue to work @oflyhigh good luck continued and many gave birth to the benefits for many people
post_id | 9,862,422 | ||||||
---|---|---|---|---|---|---|---|
author | munazir | ||||||
permlink | re-oflyhigh-2017811t20423037z | ||||||
category | cn | ||||||
json_metadata | "{"app": "esteem/1.4.6", "format": "markdown+html", "community": "esteem", "tags": "cn"}" | ||||||
created | 2017-08-11 13:42:36 | ||||||
last_update | 2017-08-11 13:42:36 | ||||||
depth | 1 | ||||||
children | 0 | ||||||
net_rshares | 101,828,369,092 | ||||||
last_payout | 2017-08-18 13:42:36 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.329 SBD | ||||||
curator_payout_value | 0.000 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 403 | ||||||
author_reputation | 613,448,032,334 | ||||||
root_title | 第一次使用STEEMSQL查询谷哥点名数据 | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||
percent_steem_dollars | 10,000 | ||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
good-karma | 0 | 101,828,369,092 | 0.5% |
Support me and enter here https://steemit.com/help/@gr3g0r/hi-i-m-from-venezuela your collaboration is important @gr3g0r Follow Me!
post_id | 9,863,431 |
---|---|
author | gr3g0r |
permlink | re-oflyhigh-steemsql-20170811t135339766z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "users": ["gr3g0r"], "links": ["https://steemit.com/help/@gr3g0r/hi-i-m-from-venezuela"], "tags": ["cn"]}" |
created | 2017-08-11 13:53:39 |
last_update | 2017-08-11 13:53:39 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 13:53:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 131 |
author_reputation | 69,716,139,996 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
I cant understand a word what this post says but it looks cool.
post_id | 9,864,404 | ||||||
---|---|---|---|---|---|---|---|
author | theoccultcorner | ||||||
permlink | re-oflyhigh-2017811t735871z | ||||||
category | cn | ||||||
json_metadata | "{"app": "esteem/1.4.6", "format": "markdown+html", "community": "esteem", "tags": "cn"}" | ||||||
created | 2017-08-11 14:03:12 | ||||||
last_update | 2017-08-11 14:03:12 | ||||||
depth | 1 | ||||||
children | 0 | ||||||
net_rshares | 0 | ||||||
last_payout | 2017-08-18 14:03:12 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.000 SBD | ||||||
curator_payout_value | 0.000 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 63 | ||||||
author_reputation | 4,136,820,402,388 | ||||||
root_title | 第一次使用STEEMSQL查询谷哥点名数据 | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||
percent_steem_dollars | 10,000 | ||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
theoccultcorner | 0 | 0 | 100% |
This language is so sexy... http://i0.kym-cdn.com/entries/icons/original/000/002/276/fap-meme.jpg Fap fap fap fap fap... Fap fap. Fap? Fap fap fap!
post_id | 9,870,075 |
---|---|
author | fapfap |
permlink | re-oflyhigh-steemsql-20170811t150625770z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "image": ["http://i0.kym-cdn.com/entries/icons/original/000/002/276/fap-meme.jpg"], "tags": ["cn"]}" |
created | 2017-08-11 15:06:24 |
last_update | 2017-08-11 15:06:24 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 15:06:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 149 |
author_reputation | 2,486,311,596,331 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
who likes my pet :) <div style="position: fixed; bottom: 0px; left: 10px;width:125px;height:160px;"><a href="http://catatan-lingga.blogspot.com/2014/05/20-widget-animasi-yang-lucu-dan-keren.html" target="_blank"><img border="0" src="http://content.sweetim.com/sim/cpie/emoticons/000203A0.gif" title="Click to get more." /></a><center><a href="http://catatan-lingga.blogspot.com/2014/05/20-widget-animasi-yang-lucu-dan-keren.html" target="_blank"></a></center></div>
post_id | 9,889,435 |
---|---|
author | imamaii |
permlink | re-oflyhigh-steemsql-20170811t191924849z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "links": ["http://catatan-lingga.blogspot.com/2014/05/20-widget-animasi-yang-lucu-dan-keren.html"], "image": ["http://content.sweetim.com/sim/cpie/emoticons/000203A0.gif"], "tags": ["cn"]}" |
created | 2017-08-11 19:19:48 |
last_update | 2017-08-11 19:19:48 |
depth | 1 |
children | 0 |
net_rshares | -1,015,402,897,182 |
last_payout | 2017-08-18 19:19:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 465 |
author_reputation | 2,332,264,370,871 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
adm | 0 | -1,277,319,196,150 | -10% | ||
blacklist-a | 0 | -52,095,934 | -10% | ||
thing-2 | 0 | 261,968,394,902 | 100% |
follow me please
post_id | 9,889,919 |
---|---|
author | justsmile |
permlink | re-oflyhigh-steemsql-20170811t192615628z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 19:26:18 |
last_update | 2017-08-11 19:26:18 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 19:26:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 16 |
author_reputation | -36,869,450,645 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Tanpa uang semua jadi kacau,, bila uang banyak saudara pun jadi rame
post_id | 9,890,071 | ||||||
---|---|---|---|---|---|---|---|
author | daniham | ||||||
permlink | re-oflyhigh-2017812t22824632z | ||||||
category | cn | ||||||
json_metadata | "{"app": "esteem/1.4.6", "format": "markdown+html", "community": "esteem", "tags": "cn"}" | ||||||
created | 2017-08-11 19:28:30 | ||||||
last_update | 2017-08-11 19:28:30 | ||||||
depth | 1 | ||||||
children | 0 | ||||||
net_rshares | 0 | ||||||
last_payout | 2017-08-18 19:28:30 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.000 SBD | ||||||
curator_payout_value | 0.000 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 69 | ||||||
author_reputation | 645,654,229,034 | ||||||
root_title | 第一次使用STEEMSQL查询谷哥点名数据 | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||
percent_steem_dollars | 10,000 |
看到我自己的文 = 已經參加了,可以放心去睡了 XD 雖然看不明白內容 (逃)
post_id | 9,890,167 |
---|---|
author | biuiam |
permlink | re-oflyhigh-steemsql-20170811t192957149z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-11 19:29:57 |
last_update | 2017-08-11 19:29:57 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-18 19:29:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 39 |
author_reputation | 71,889,699,236,580 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Really post is very nice and impressive but i don,t know this language
post_id | 9,916,502 |
---|---|
author | sharoon |
permlink | re-oflyhigh-steemsql-20170812t034448884z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-12 03:44:45 |
last_update | 2017-08-12 03:44:45 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-19 03:44:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 70 |
author_reputation | -330,285,029,183 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
I wish I could understand chinese. I am learning chinese through google translator. New language is always good. Upvoted
post_id | 9,943,184 |
---|---|
author | shasol |
permlink | re-oflyhigh-steemsql-20170812t122923914z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-12 12:29:42 |
last_update | 2017-08-12 12:29:42 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-19 12:29:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 120 |
author_reputation | 26,709,555,875 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Congratulations @oflyhigh! Your post was mentioned in the [hit parade](https://steemit.com/hit-parade/@arcange/daily-hit-parade-20170811) in the following categories: * Upvotes - Ranked 10 with 310 upvotes * Pending payout - Ranked 5 with $ 331,57
post_id | 9,951,486 |
---|---|
author | arcange |
permlink | re-steemsql-20170811t163414000z |
category | cn |
json_metadata | {} |
created | 2017-08-12 14:33:03 |
last_update | 2017-08-12 14:33:03 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-19 14:33:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 249 |
author_reputation | 231,443,210,169,699 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
哇!谢谢分享^^值得收藏
post_id | 9,954,042 |
---|---|
author | sweeti |
permlink | re-oflyhigh-steemsql-20170812t150922523z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-12 15:09:45 |
last_update | 2017-08-12 15:09:45 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-19 15:09:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 12 |
author_reputation | 8,555,043,501,451 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
关键知识点:like N'%区块链%'"
post_id | 10,055,846 |
---|---|
author | tvb |
permlink | re-oflyhigh-steemsql-20170813t213307834z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-08-13 21:33:12 |
last_update | 2017-08-13 21:33:54 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-08-20 21:33:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 20 |
author_reputation | 35,846,309,024,528 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
顶一下,现在正被这个中文字符编码显示问题困扰中。@justyy 把我引过来的。
post_id | 17,426,150 |
---|---|
author | eduter |
permlink | re-oflyhigh-steemsql-20171111t194445917z |
category | cn |
json_metadata | "{"app": "steemit/0.1", "tags": ["cn"]}" |
created | 2017-11-11 19:44:09 |
last_update | 2017-11-11 19:44:09 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-11-18 19:44:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 39 |
author_reputation | 3,336,824,252,282 |
root_title | 第一次使用STEEMSQL查询谷哥点名数据 |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |