Viewing a response to: @ace108/til-steemsql-use-case-very-similar-comments-by-some-users-scary-occurrences-by-ace108
Nice! Did you write the query yourself? I didn't know you know how to write SQL queries? I haven't had time to play around with SteemSQL yet :]
| post_id | 8,246,184 |
|---|---|
| author | msg768 |
| permlink | re-ace108-til-steemsql-use-case-very-similar-comments-by-some-users-scary-occurrences-by-ace108-20170725t143736227z |
| category | myexperiment |
| json_metadata | "{"app": "steemit/0.1", "tags": ["myexperiment"]}" |
| created | 2017-07-25 14:37:33 |
| last_update | 2017-07-25 14:37:33 |
| depth | 1 |
| children | 3 |
| net_rshares | 0 |
| last_payout | 2017-08-01 14: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 | 143 |
| author_reputation | 29,892,040,056,464 |
| root_title | "#TIL STEEMSQL use case -very similar comments by some users. Scary occurrences? (by @ace108)" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
Yes, I did. Did a lot or SQL but has to learn some things with Google's help because the SQL I worked with is mostly Oracle and this steemsql is SQL Server. :-)
| post_id | 8,288,938 |
|---|---|
| author | ace108 |
| permlink | re-msg768-re-ace108-til-steemsql-use-case-very-similar-comments-by-some-users-scary-occurrences-by-ace108-20170725t225013638z |
| category | myexperiment |
| json_metadata | "{"app": "steemit/0.1", "tags": ["myexperiment"]}" |
| created | 2017-07-25 22:50:15 |
| last_update | 2017-07-25 22:50:15 |
| depth | 2 |
| children | 2 |
| net_rshares | 0 |
| last_payout | 2017-08-01 22:50: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 | 160 |
| author_reputation | 588,843,655,355,588 |
| root_title | "#TIL STEEMSQL use case -very similar comments by some users. Scary occurrences? (by @ace108)" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
Oracle, SQL Server and MySQL are all very similar though :]
| post_id | 8,300,432 |
|---|---|
| author | msg768 |
| permlink | re-ace108-re-msg768-re-ace108-til-steemsql-use-case-very-similar-comments-by-some-users-scary-occurrences-by-ace108-20170726t012611542z |
| category | myexperiment |
| json_metadata | "{"app": "steemit/0.1", "tags": ["myexperiment"]}" |
| created | 2017-07-26 01:26:21 |
| last_update | 2017-07-26 01:26:21 |
| depth | 3 |
| children | 1 |
| net_rshares | 0 |
| last_payout | 2017-08-02 01:26:21 |
| 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 | 29,892,040,056,464 |
| root_title | "#TIL STEEMSQL use case -very similar comments by some users. Scary occurrences? (by @ace108)" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
Similar enough but the minor differences are sometimes a pain requiring much googling. :-)
| post_id | 8,364,679 |
|---|---|
| author | ace108 |
| permlink | re-msg768-re-ace108-re-msg768-re-ace108-til-steemsql-use-case-very-similar-comments-by-some-users-scary-occurrences-by-ace108-20170726t154312969z |
| category | myexperiment |
| json_metadata | "{"app": "steemit/0.1", "tags": ["myexperiment"]}" |
| created | 2017-07-26 15:43:09 |
| last_update | 2017-07-26 15:43:09 |
| depth | 4 |
| children | 0 |
| net_rshares | 0 |
| last_payout | 2017-08-02 15:43: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 | 90 |
| author_reputation | 588,843,655,355,588 |
| root_title | "#TIL STEEMSQL use case -very similar comments by some users. Scary occurrences? (by @ace108)" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |