Hi guys!
I'm far from a database expert but still remember SQL from long time ago when there were no objects or libraries and we had to develop our own DLL, in the good old days of Borland C++, Informix or SCO UNIX.
Hidden Spoiler Text
Yes I started code before Linux! lol
Does anyone remember those funny times?
Well, let's stop being nostalgic and lets SQL lol
I've used HiveSQL https://docs.hivesql.io/ to this very simple query!
Time frame is first 4 months of 2023 and the query is, actually 3 queries because it make sense.
- Top 20 authors reblogged
- Top 20 Rebloggers
- Top 10 authors reblogged by the top reblogger
Top 20 authors reblogged (Jan to Apr 2023)
SQL Query
SELECT TOP 20 COUNT(account), author
FROM Reblogs (NOLOCK)
WHERE CONVERT (DATE, timestamp) BETWEEN '2023-01-01' AND '2023-04-30'
GROUP BY author
ORDER BY COUNT(account) DESC
| Number of Reblogs | Author |
|---|---|
| 6584 | ebargains |
| 3709 | noctury |
| 2631 | taskmaster4450 |
| 2512 | ocd |
| 2138 | galenkp |
| 2060 | arcange |
| 1805 | yeckingo1 |
| 1795 | readthisplease |
| 1779 | splinterlands |
| 1738 | curangel |
| 1676 | mariajcastro28 |
| 1627 | acidyo |
| 1620 | ifarmgirl |
| 1429 | heartbeatonhive |
| 1369 | joetunex |
| 1357 | tattoodjay |
| 1340 | alive.chat |
| 1320 | ladiesofhive |
| 1309 | monica-ene |
| 1308 | nkemakonam89 |
Top 20 Rebloggers (Jan to Apr 2023)
SQL Query
SELECT TOP 20 COUNT(author), account
FROM Reblogs (NOLOCK)
WHERE CONVERT (DATE, timestamp) BETWEEN '2023-01-01' AND '2023-04-30'
GROUP BY account
ORDER BY COUNT(author) DESC
| Reblogger | Number of posts reblogged |
|---|---|
| marcocasario | 23377 |
| gasaeightyfive | 22066 |
| cribbio | 22057 |
| oadissin | 18403 |
| dgi | 16195 |
| pixresteemer | 7500 |
| psyber-x | 5469 |
| flaxz.alive | 4526 |
| hive.games | 4401 |
| omarrojas | 4239 |
| valenpba | 3100 |
| sacra97 | 2765 |
| roronoa46 | 2396 |
| dynamicgreen | 2389 |
| jongcl | 2295 |
| psyberkiller | 2268 |
| flaxz.ctp | 2253 |
| edgerik | 2245 |
| alizmarpaola | 2226 |
| mariajcastro28 | 2202 |
Top 10 authors reblogged by the top reblogger (Jan to Apr 2023)
SQL Query
SELECT TOP 10 COUNT(author), author
FROM Reblogs (NOLOCK)
WHERE CONVERT (DATE, timestamp) BETWEEN '2023-01-01' AND '2023-04-30' AND account ='marcocasario'
GROUP BY author
ORDER BY COUNT(author) DESC
| Author | Number of posts reblogged |
|---|---|
| taskmaster4450 | 267 |
| readthisplease | 264 |
| arcange | 216 |
| hironakamura | 197 |
| tarazkp | 160 |
| qurator | 156 |
| noctury | 147 |
| svanbo | 128 |
| sumotori | 127 |
| yolimarag | 126 |
Hope you found these simple collection of Blockchain Data interesting.
Thank for following me!
https://leofinance.io/threads/@doze/re-leothreads-2zpdytppn
The rewards earned on this comment will go directly to the people ( doze ) sharing the post on LeoThreads,LikeTu,dBuzz.
Hey @doze. I'm so glad you shared this. I'm building some things to enhance my project and this is good for me. I'll save your post for when I need it later. Thank you!
You're most welcome