SteemSQL Wrapper, jette un oeil aux données Steem ! by roxane

View this thread on steempeak.com
utopian-io · @roxane · (edited)
$62.86
SteemSQL Wrapper, jette un oeil aux données Steem !
>This video is explaining what is SteemSQL Wrapper and how and why to use it. The language used is french.

<br>

Voici un tout nouveau projet dont presque (si ce n'est même personne excepté le développeur) n'en a parlé ! Et pourtant... Je vous promets, que c'est sympa... Si vous aimez les données! 

Suivez-moi, je vous fais visiter SteemSQL en vidéo. 

<br>


<iframe width="560" height="315" src="https://www.youtube.com/embed/b18I_SzWOIU" frameborder="0" gesture="media" allow="encrypted-media" allowfullscreen></iframe>

<br>

Cette application web est développé par @emptyname. 

Essayez SteemSQL Wrapper en allant sur [sql.steemhelpers.com](https://sql.steemhelpers.com/)
Présentation du projet (en anglais) : [SteemSQL Wrapper](https://steemit.com/utopian-io/@emptyname/steemsql-wrapper-analyze-any-steemit-data-right-in-your-browser-with-one-click) 

### Articles les plus commentés
```
SELECT title AS [titre], children AS [commentaires], url
FROM Comments (NOLOCK)
WHERE
    author = 'roxane'
ORDER BY children DESC
```

### Stats globales par mois
```
SELECT YEAR(created) AS [année], MONTH(created) AS [mois], COUNT(*) AS [articles], SUM(net_votes) AS votes, SUM(children) AS commentaires
FROM Comments (NOLOCK)
WHERE
    author = 'roxane'
    AND depth = 0
    AND created > '2016-01-01'
GROUP BY YEAR(created), MONTH(created)
ORDER BY YEAR(created), MONTH(created)
```

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@roxane/steemsql-wrapper-jette-un-oeil-aux-donnees-steem">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
post_id20,714,614
authorroxane
permlinksteemsql-wrapper-jette-un-oeil-aux-donnees-steem
categoryutopian-io
json_metadata"{"type": "video-tutorials", "repository": {"id": 114453017, "watchers": 0, "events_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/events", "forks": 0, "name": "steemsql-wrapper", "issues_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/issues{/number}", "trees_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/git/trees{/sha}", "fork": false, "git_url": "git://github.com/sihaelov/steemsql-wrapper.git", "assignees_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/assignees{/user}", "size": 1241, "owner": {"id": 20229528, "following_url": "https://api.github.com/users/sihaelov/following{/other_user}", "starred_url": "https://api.github.com/users/sihaelov/starred{/owner}{/repo}", "subscriptions_url": "https://api.github.com/users/sihaelov/subscriptions", "repos_url": "https://api.github.com/users/sihaelov/repos", "login": "sihaelov", "gists_url": "https://api.github.com/users/sihaelov/gists{/gist_id}", "followers_url": "https://api.github.com/users/sihaelov/followers", "received_events_url": "https://api.github.com/users/sihaelov/received_events", "type": "User", "avatar_url": "https://avatars2.githubusercontent.com/u/20229528?v=4", "site_admin": false, "organizations_url": "https://api.github.com/users/sihaelov/orgs", "gravatar_id": "", "events_url": "https://api.github.com/users/sihaelov/events{/privacy}", "url": "https://api.github.com/users/sihaelov", "html_url": "https://github.com/sihaelov"}, "forks_count": 0, "git_refs_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/git/refs{/sha}", "blobs_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/git/blobs{/sha}", "pushed_at": "2017-12-16T10:57:54Z", "watchers_count": 0, "teams_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/teams", "comments_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/comments{/number}", "archived": false, "svn_url": "https://github.com/sihaelov/steemsql-wrapper", "merges_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/merges", "subscribers_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/subscribers", "issue_events_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/issues/events{/number}", "stargazers_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/stargazers", "mirror_url": null, "statuses_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/statuses/{sha}", "has_projects": true, "milestones_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/milestones{/number}", "description": "SteemSQL Wrapper", "keys_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/keys{/key_id}", "open_issues": 0, "compare_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/compare/{base}...{head}", "ssh_url": "git@github.com:sihaelov/steemsql-wrapper.git", "license": null, "html_url": "https://github.com/sihaelov/steemsql-wrapper", "commits_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/commits{/sha}", "open_issues_count": 0, "stargazers_count": 0, "branches_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/branches{/branch}", "full_name": "sihaelov/steemsql-wrapper", "forks_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/forks", "score": 19.82666, "deployments_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/deployments", "contributors_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/contributors", "homepage": "", "contents_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/contents/{+path}", "has_downloads": true, "collaborators_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/collaborators{/collaborator}", "created_at": "2017-12-16T10:45:04Z", "git_commits_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/git/commits{/sha}", "releases_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/releases{/id}", "private": false, "pulls_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/pulls{/number}", "git_tags_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/git/tags{/sha}", "notifications_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/notifications{?since,all,participating}", "language": "JavaScript", "updated_at": "2017-12-16T10:51:22Z", "has_wiki": true, "downloads_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/downloads", "hooks_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/hooks", "languages_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/languages", "default_branch": "master", "labels_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/labels{/name}", "url": "https://api.github.com/repos/sihaelov/steemsql-wrapper", "has_pages": false, "tags_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/tags", "clone_url": "https://github.com/sihaelov/steemsql-wrapper.git", "archive_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/{archive_format}{/ref}", "has_issues": true, "issue_comment_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/issues/comments{/number}", "subscription_url": "https://api.github.com/repos/sihaelov/steemsql-wrapper/subscription"}, "pullRequests": [], "format": "markdown", "image": ["https://img.youtube.com/vi/b18I_SzWOIU/0.jpg"], "links": ["https://www.youtube.com/embed/b18I_SzWOIU", "https://sql.steemhelpers.com/", "https://steemit.com/utopian-io/@emptyname/steemsql-wrapper-analyze-any-steemit-data-right-in-your-browser-with-one-click", "https://utopian.io/utopian-io/@roxane/steemsql-wrapper-jette-un-oeil-aux-donnees-steem"], "app": "steemit/0.1", "platform": "github", "tags": ["utopian-io", "steem", "stats", "steemdev", "howto"], "community": "utopian", "users": ["emptyname"]}"
created2017-12-17 00:35:48
last_update2017-12-17 11:57:42
depth0
children7
net_rshares12,408,400,910,971
last_payout2017-12-24 00:35:48
cashout_time1969-12-31 23:59:59
total_payout_value51.090 SBD
curator_payout_value11.771 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,570
author_reputation162,596,469,388,148
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries
0.
accountutopian.pay
weight2,500
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (57)
@sorayakhatun · 
i liked this post because you is a gtreat
👎  
properties (23)
post_id20,714,816
authorsorayakhatun
permlinkre-roxane-steemsql-wrapper-jette-un-oeil-aux-donnees-steem-20171217t003834628z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
created2017-12-17 00:38:42
last_update2017-12-17 00:38:42
depth1
children0
net_rshares-21,683,416,788
last_payout2017-12-24 00:38:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length41
author_reputation16,259,646,938,814
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@enews202 · 
reasteam done please check my profile
👎  
properties (23)
post_id20,714,865
authorenews202
permlinkre-roxane-steemsql-wrapper-jette-un-oeil-aux-donnees-steem-20171217t003912662z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
created2017-12-17 00:39:21
last_update2017-12-17 00:39:21
depth1
children0
net_rshares-21,683,416,788
last_payout2017-12-24 00:39:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length37
author_reputation468,933,340,012
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@cameron99 · 
Ouu.Although I don't know French language,but I sold on that it is useful about SteemSQL WRAPPER. :) I express my gratitude to you,@roxane
properties (22)
post_id20,714,983
authorcameron99
permlinkre-roxane-steemsql-wrapper-jette-un-oeil-aux-donnees-steem-20171217t004107450z
categoryutopian-io
json_metadata"{"app": "busy/2.1.0", "community": "busy", "tags": ["utopian-io"]}"
created2017-12-17 00:41:09
last_update2017-12-17 00:41:09
depth1
children0
net_rshares0
last_payout2017-12-24 00:41:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length138
author_reputation13,081,774,742,601
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@stoodkev ·
$0.83
Sympa! Je connaissais pas.
👍  
properties (23)
post_id20,724,466
authorstoodkev
permlinkre-roxane-20171217t11133805z
categoryutopian-io
json_metadata"{"app": "esteem/1.5.0", "format": "markdown+html", "community": "esteem", "tags": ["utopian-io", "steem", "stats", "steemdev", "howto"]}"
created2017-12-17 03:01:36
last_update2017-12-17 03:01:36
depth1
children1
net_rshares134,306,013,512
last_payout2017-12-24 03:01:36
cashout_time1969-12-31 23:59:59
total_payout_value0.619 SBD
curator_payout_value0.214 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length26
author_reputation89,353,405,873,727
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries
0.
accountesteemapp
weight500
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@roxane · 
C'est tout chaud, ça vient de sortir visiblement ;-) @stoodkev
properties (22)
post_id20,735,750
authorroxane
permlinkre-stoodkev-re-roxane-20171217t11133805z-20171217t054739762z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "users": ["stoodkev"], "tags": ["utopian-io"]}"
created2017-12-17 05:47:39
last_update2017-12-17 05:47:39
depth2
children0
net_rshares0
last_payout2017-12-24 05:47:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length62
author_reputation162,596,469,388,148
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@omeratagun · 
Thank you for the contribution. It has been approved.

* Hey @roxane, i was wondering how to reach it. Personally i got this. Keep up on good work! Regards.

You can contact us on [Discord](https://discord.gg/UCvqCsx).
**[[utopian-moderator]](https://utopian.io/moderators)**
properties (22)
post_id21,043,002
authoromeratagun
permlinkre-roxane-steemsql-wrapper-jette-un-oeil-aux-donnees-steem-20171219t135507179z
categoryutopian-io
json_metadata"{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}"
created2017-12-19 13:55:09
last_update2017-12-19 13:55:09
depth1
children0
net_rshares0
last_payout2017-12-26 13:55:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length275
author_reputation30,354,439,797,907
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@utopian-io · 
### Hey @roxane I am @utopian-io. I have just upvoted you!
#### Achievements
- You are generating more rewards than average for this category. Super!;)
- Seems like you contribute quite often. AMAZING!
#### Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. <a href="https://discord.gg/zTrEMqB">Participate on Discord</a>. Lets GROW TOGETHER!
- <a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for my Witness With SteemConnect</a>
- <a href="https://v2.steemconnect.com/sign/account-witness-proxy?proxy=utopian-io&approve=1">Proxy vote to Utopian Witness with SteemConnect</a>
- Or vote/proxy on <a href="https://steemit.com/~witnesses">Steemit Witnesses</a>

[![mooncryption-utopian-witness-gif](https://steemitimages.com/DQmYPUuQRptAqNBCQRwQjKWAqWU3zJkL3RXVUtEKVury8up/mooncryption-s-utopian-io-witness-gif.gif)](https://steemit.com/~witnesses)

**Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x**
properties (22)
post_id21,108,022
authorutopian-io
permlinkre-roxane-steemsql-wrapper-jette-un-oeil-aux-donnees-steem-20171219t232936329z
categoryutopian-io
json_metadata"{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}"
created2017-12-19 23:29:36
last_update2017-12-19 23:29:36
depth1
children0
net_rshares0
last_payout2017-12-26 23:29:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,079
author_reputation152,913,012,544,965
root_title"SteemSQL Wrapper, jette un oeil aux données Steem !"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
Help/Feedback