create account

I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting! by macchiata

View this thread on: hive.blogpeakd.comecency.com
· @macchiata ·
$6.74
I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!
![Mac Property(19).png](https://files.peakd.com/file/peakd-hive/macchiata/246b2fmdczE1sraVi2tMyeMxbJJWaK3mSUgBcoXYpUCMgTQrx9hcbzjpT7j8V4kRFZUUg.png)



There's this awesome tools by @arcange called HiveSQL and if you haven't supported the proposal check out the proposal to keep HIVESQL price "Free" to use ( although you still have to pay 1 HBD) ๐Ÿ˜‚ but it's worth it, **I promise**. Here's the link to the proposal that you can vote on :

<div class="text-justify">

https://peakd.com/hive-139531/@hivesql/poposal-2526


# It all started from this one problem... 

I don't know what got to me but recently, I got back into a problem that's been on my back burner for a while. 

## The problem is simple " unfollowing @lovesniper following that has rep equals and to above 60" 

In the past, I am unfollowing them manually as soon as I see rep "60" but the thing is, the following list keeps growing and it was to the point that I can't keep up. I am not sure if others who's also in @lovesniper feels the same way. So, I thought about how can I sort them easily? 

<center> ![macbrand.png](https://files.peakd.com/file/peakd-hive/macchiata/23sweD6vycN7cwFdHaLE8Ze8ayocMSDoWEAgUZqFJJ9kCXshFpN3tDPaDhXgZr3fLV5ZQ.png) </center>



I tried using HIVESQL with python but somehow, I just couldn't grasp it or maybe I was a noob? So about almost a year has passed today and I finally figured it out. 

The thing is, I recently tried MYSQL again and as much as the flow of the query is still the same, HiveSQL works faster with SSMS ( SQL Server Management Studio). So, after configuring my SSMS, today I learned the rope to retrieve data and write some of my first queries. 

As much as perhaps python would have done it faster and automate it, this is what I find with SQL. 



<center> ![macbrand.png](https://files.peakd.com/file/peakd-hive/macchiata/23sweD6vycN7cwFdHaLE8Ze8ayocMSDoWEAgUZqFJJ9kCXshFpN3tDPaDhXgZr3fLV5ZQ.png) </center>


### How did I solve that problem As a noob? 


- You just have to connect to the HiveSQL (their documentation is pretty extensive)
- Learn how the database diagram works and that's where you'll most likely refer to
- Read the documentation
- Understand some basics
- Write the queries 


```
SQL 

SELECT u.username, u.reputation, u.reputation_ui			
FROM Followers f			
JOIN Users u ON f.following = u.username			
WHERE f.follower = 'insert username' AND u.reputation > insert numerical number		

```

The core of SQL is basically SELECT, FROM, WHERE. The interesting part happens in "WHERE" as you can includes conditionals and basically the things that you want to do. 

I noticed one thing with SQL is that it doesn't accept LIMIT so I have to use TOP command to "limit" the data that I want to gather. 


Thanks to documentation by hivesql and as long as you read it, nothing is impossible. You can get whatever data available that you want to know. 

</div>


<center> ![macbrand.png](https://files.peakd.com/file/peakd-hive/macchiata/23sweD6vycN7cwFdHaLE8Ze8ayocMSDoWEAgUZqFJJ9kCXshFpN3tDPaDhXgZr3fLV5ZQ.png) </center>


<center> Don't hesitate to upvote for more content like this ! You can also support me below! </center>

<center> <a href='https://buymeberri.es/@macchiata' target='_blank'><img src='https://buymeberries.com/assets/bmb-4-s.png'/></a></center>


|||
|-|-
|![profilepic.jpg](https://files.peakd.com/file/peakd-hive/macchiata/AKqch2qeXxDgtt6gewBnVB28roLauVcnbF5T9dypQyjYTV1DhG9mmkdEo7HYkMv.jpg)| <div class="text-justify">๐˜”๐˜ข๐˜ค ๐˜ช๐˜ด ๐˜ข ๐˜ด๐˜ฆ๐˜ญ๐˜ง-๐˜ฆ๐˜ฎ๐˜ฑ๐˜ญ๐˜ฐ๐˜บ๐˜ฆ๐˜ฅ ๐˜ฏ๐˜ช๐˜ฏ๐˜ซ๐˜ข & ๐˜ค๐˜ฐ๐˜ง๐˜ง๐˜ฆ๐˜ฆ ๐˜ค๐˜ฐ๐˜ฏ๐˜ฏ๐˜ฐ๐˜ช๐˜ด๐˜ด๐˜ฆ๐˜ถ๐˜ณ . ๐˜ˆ ๐˜ต๐˜บ๐˜ฑ๐˜ช๐˜ค๐˜ข๐˜ญ ๐˜ช๐˜ฏ๐˜ต๐˜ณ๐˜ฐ๐˜ท๐˜ฆ๐˜ณ๐˜ต ๐˜ช๐˜ฏ ๐˜ญ๐˜ฐ๐˜ท๐˜ฆ ๐˜ธ๐˜ช๐˜ต๐˜ฉ ๐˜ญ๐˜ช๐˜ต๐˜ฆ๐˜ณ๐˜ข๐˜ต๐˜ถ๐˜ณ๐˜ฆ, ๐˜ฃ๐˜ฐ๐˜ฐ๐˜ฌ๐˜ด, ๐˜ต๐˜ฆ๐˜ค๐˜ฉ๐˜ฏ๐˜ฐ๐˜ญ๐˜ฐ๐˜จ๐˜บ ๐˜ข๐˜ฏ๐˜ฅ ๐˜ฑ๐˜ฉ๐˜ช๐˜ญ๐˜ฐ๐˜ด๐˜ฐ๐˜ฑ๐˜ฉ๐˜บ.  ๐˜›๐˜ฉ๐˜ช๐˜ด ๐˜ช๐˜ด ๐˜ฉ๐˜ฆ๐˜ณ ๐˜ฑ๐˜ฆ๐˜ณ๐˜ด๐˜ฐ๐˜ฏ๐˜ข๐˜ญ ๐˜ฃ๐˜ญ๐˜ฐ๐˜จ, ๐˜ข ๐˜ณ๐˜ฆ๐˜ง๐˜ญ๐˜ฆ๐˜ค๐˜ต๐˜ช๐˜ฐ๐˜ฏ ๐˜ฐ๐˜ง ๐˜ฉ๐˜ฆ๐˜ณ ๐˜ธ๐˜ข๐˜ฏ๐˜ฅ๐˜ฆ๐˜ณ๐˜ญ๐˜ถ๐˜ด๐˜ต ๐˜ข๐˜ฏ๐˜ฅ ๐˜ต๐˜ฉ๐˜ช๐˜ณ๐˜ด๐˜ต ๐˜ง๐˜ฐ๐˜ณ ๐˜ฌ๐˜ฏ๐˜ฐ๐˜ธ๐˜ญ๐˜ฆ๐˜ฅ๐˜จ๐˜ฆ. ๐˜š๐˜ฉ๐˜ฆ ๐˜ฐ๐˜ง๐˜ต๐˜ฆ๐˜ฏ ๐˜ค๐˜ฐ๐˜ท๐˜ฆ๐˜ณ๐˜ด **๐˜ฃ๐˜ฐ๐˜ฐ๐˜ฌ๐˜ด, ๐˜ฎ๐˜ฐ๐˜ท๐˜ช๐˜ฆ ๐˜ข๐˜ฏ๐˜ฅ ๐˜ด๐˜ฆ๐˜ณ๐˜ช๐˜ฆ๐˜ด ๐˜ณ๐˜ฆ๐˜ท๐˜ช๐˜ฆ๐˜ธ๐˜ด, ๐˜ต๐˜ฆ๐˜ค๐˜ฉ ๐˜ณ๐˜ฆ๐˜ท๐˜ช๐˜ฆ๐˜ธ๐˜ด ๐˜ข๐˜ฏ๐˜ฅ ๐˜ต๐˜ณ๐˜ฆ๐˜ฏ๐˜ฅ๐˜ด, ๐˜ฑ๐˜ฉ๐˜ฐ๐˜ต๐˜ฐ๐˜จ๐˜ณ๐˜ข๐˜ฑ๐˜ฉ๐˜บ, ๐˜ข๐˜ฏ๐˜ฅ ๐˜ฑ๐˜ฆ๐˜ณ๐˜ด๐˜ฐ๐˜ฏ๐˜ข๐˜ญ ๐˜ฅ๐˜ฆ๐˜ท๐˜ฆ๐˜ญ๐˜ฐ๐˜ฑ๐˜ฎ๐˜ฆ๐˜ฏ๐˜ต**. ๐˜–๐˜ฏ๐˜ค๐˜ฆ ๐˜ช๐˜ฏ ๐˜ข ๐˜ฃ๐˜ญ๐˜ถ๐˜ฆ ๐˜ฎ๐˜ฐ๐˜ฐ๐˜ฏ, ๐˜บ๐˜ฐ๐˜ถ ๐˜ค๐˜ข๐˜ฏ ๐˜ง๐˜ช๐˜ฏ๐˜ฅ ๐˜ฉ๐˜ฆ๐˜ณ ๐˜ต๐˜ณ๐˜ข๐˜ท๐˜ฆ๐˜ญ๐˜ช๐˜ฏ๐˜จ, ๐˜ช๐˜ฎ๐˜ฎ๐˜ฆ๐˜ณ๐˜ด๐˜ช๐˜ฏ๐˜จ ๐˜ฉ๐˜ฆ๐˜ณ๐˜ด๐˜ฆ๐˜ญ๐˜ง ๐˜ช๐˜ฏ ๐˜ญ๐˜ฐ๐˜ค๐˜ข๐˜ญ ๐˜ค๐˜ถ๐˜ญ๐˜ต๐˜ถ๐˜ณ๐˜ฆ๐˜ด ๐˜ข๐˜ฏ๐˜ฅ ๐˜ต๐˜ณ๐˜ข๐˜ฅ๐˜ช๐˜ต๐˜ช๐˜ฐ๐˜ฏ๐˜ด, ๐˜ข๐˜ฏ๐˜ฅ ๐˜ต๐˜ข๐˜ฌ๐˜ช๐˜ฏ๐˜จ ๐˜ฑ๐˜ช๐˜ค๐˜ต๐˜ถ๐˜ณ๐˜ฆ๐˜ด ๐˜ฐ๐˜ง ๐˜ต๐˜ฉ๐˜ฆ ๐˜ฃ๐˜ฆ๐˜ข๐˜ถ๐˜ต๐˜ช๐˜ง๐˜ถ๐˜ญ ๐˜ด๐˜ช๐˜จ๐˜ฉ๐˜ต๐˜ด ๐˜ด๐˜ฉ๐˜ฆ ๐˜ฆ๐˜ฏ๐˜ค๐˜ฐ๐˜ถ๐˜ฏ๐˜ต๐˜ฆ๐˜ณ๐˜ด ๐˜ข๐˜ญ๐˜ฐ๐˜ฏ๐˜จ ๐˜ต๐˜ฉ๐˜ฆ ๐˜ธ๐˜ข๐˜บ. ๐˜š๐˜ฉ๐˜ฆ'๐˜ด ๐˜ข๐˜ฏ ๐˜ฐ๐˜ค๐˜ค๐˜ข๐˜ด๐˜ช๐˜ฐ๐˜ฏ๐˜ข๐˜ญ ๐˜ง๐˜ฐ๐˜ฐ๐˜ฅ๐˜ช๐˜ฆ ๐˜ข๐˜ฏ๐˜ฅ ๐˜ญ๐˜ฐ๐˜ท๐˜ฆ๐˜ด ๐˜ต๐˜ฐ ๐˜ฆ๐˜น๐˜ฑ๐˜ญ๐˜ฐ๐˜ณ๐˜ฆ ๐˜ฏ๐˜ฆ๐˜ธ ๐˜ข๐˜ฏ๐˜ฅ ๐˜ฅ๐˜ฆ๐˜ญ๐˜ช๐˜ค๐˜ช๐˜ฐ๐˜ถ๐˜ด ๐˜ค๐˜ถ๐˜ญ๐˜ช๐˜ฏ๐˜ข๐˜ณ๐˜บ ๐˜ฆ๐˜น๐˜ฑ๐˜ฆ๐˜ณ๐˜ช๐˜ฆ๐˜ฏ๐˜ค๐˜ฆ๐˜ด. ๐˜๐˜ฐ๐˜ญ๐˜ญ๐˜ฐ๐˜ธ ๐˜ข๐˜ญ๐˜ฐ๐˜ฏ๐˜จ ๐˜ฐ๐˜ฏ ๐˜ฉ๐˜ฆ๐˜ณ ๐˜ข๐˜ฅ๐˜ท๐˜ฆ๐˜ฏ๐˜ต๐˜ถ๐˜ณ๐˜ฆ๐˜ด ๐˜ข๐˜ฏ๐˜ฅ ๐˜ซ๐˜ฐ๐˜ช๐˜ฏ ๐˜ต๐˜ฉ๐˜ฆ ๐˜ค๐˜ฐ๐˜ฏ๐˜ท๐˜ฆ๐˜ณ๐˜ด๐˜ข๐˜ต๐˜ช๐˜ฐ๐˜ฏ! ๐˜‹๐˜ฐ๐˜ฏ'๐˜ต ๐˜ฉ๐˜ฆ๐˜ด๐˜ช๐˜ต๐˜ข๐˜ต๐˜ฆ ๐˜ต๐˜ฐ ๐˜ถ๐˜ฑ๐˜ท๐˜ฐ๐˜ต๐˜ฆ, ๐˜ญ๐˜ฆ๐˜ข๐˜ท๐˜ฆ ๐˜ข ๐˜ค๐˜ฐ๐˜ฎ๐˜ฎ๐˜ฆ๐˜ฏ๐˜ต ๐˜ฐ๐˜ณ ๐˜ข ๐˜ง๐˜ฆ๐˜ฆ๐˜ฅ๐˜ฃ๐˜ข๐˜ค๐˜ฌ. ๐˜ˆ ๐˜ณ๐˜ฆ-๐˜ฃ๐˜ญ๐˜ฐ๐˜จ ๐˜ช๐˜ด ๐˜ข๐˜ญ๐˜ด๐˜ฐ ๐˜ข๐˜ฑ๐˜ฑ๐˜ณ๐˜ฆ๐˜ค๐˜ช๐˜ข๐˜ต๐˜ฆ๐˜ฅ ๐˜ต๐˜ฐ๐˜ฐ.</div> |</center>

๐Ÿ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 70 others
properties (23)
authormacchiata
permlinki-just-learned-how-to-sort-following-list-by-reputation-with-hivesqlfeels-silly-but-exciting
categoryhive-155735
json_metadata{"app":"peakd/2025.2.3","format":"markdown","tags":["sql","learn2code","howto","mysql","hivesql","tech"],"users":["arcange","hivesql","lovesniper","macchiata"],"image":["https://files.peakd.com/file/peakd-hive/macchiata/246b2fmdczE1sraVi2tMyeMxbJJWaK3mSUgBcoXYpUCMgTQrx9hcbzjpT7j8V4kRFZUUg.png","https://files.peakd.com/file/peakd-hive/macchiata/23sweD6vycN7cwFdHaLE8Ze8ayocMSDoWEAgUZqFJJ9kCXshFpN3tDPaDhXgZr3fLV5ZQ.png","https://buymeberries.com/assets/bmb-4-s.png","https://files.peakd.com/file/peakd-hive/macchiata/AKqch2qeXxDgtt6gewBnVB28roLauVcnbF5T9dypQyjYTV1DhG9mmkdEo7HYkMv.jpg"]}
created2025-02-15 16:41:48
last_update2025-02-15 16:41:48
depth0
children15
last_payout2025-02-22 16:41:48
cashout_time1969-12-31 23:59:59
total_payout_value3.383 HBD
curator_payout_value3.360 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length4,246
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,810,991
net_rshares15,593,331,323,434
author_curate_reward""
vote details (134)
@gunu1 ·
I'll have to check this out, it's always good seeing dev tools for programmers like myself 
properties (22)
authorgunu1
permlinkre-macchiata-2025219t84748256z
categoryhive-155735
json_metadata{"type":"comment","tags":["hive-155735","sql","learn2code","howto","mysql","hivesql","tech"],"app":"ecency/3.2.1-mobile","format":"markdown+html"}
created2025-02-19 08:47:48
last_update2025-02-19 08:47:48
depth1
children1
last_payout2025-02-26 08:47: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_length91
author_reputation10,604,089,175,916
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,895,772
net_rshares0
@macchiata ·
Check it out, you can learn quite a bit from them.
๐Ÿ‘  
properties (23)
authormacchiata
permlinkre-gunu1-srzccg
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3"}
created2025-02-20 11:38:42
last_update2025-02-20 11:38:42
depth2
children0
last_payout2025-02-27 11:38: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_length50
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,922,364
net_rshares0
author_curate_reward""
vote details (1)
@livinguktaiwan ·
$0.02
>You just have to connect to the HiveSQL (their documentation is pretty extensive)
Learn how the database diagram works and that's where you'll most likely refer to
Read the documentation
Understand some basics
Write the queries


You make it sound do easy ! Great work for sussing it out. 
I would have taken the lazy route and beg others to help me out ๐Ÿ˜‚
๐Ÿ‘  ,
properties (23)
authorlivinguktaiwan
permlinkre-macchiata-srqrps
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-15 20:32:15
last_update2025-02-15 20:32:15
depth1
children1
last_payout2025-02-22 20:32:15
cashout_time1969-12-31 23:59:59
total_payout_value0.012 HBD
curator_payout_value0.012 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length357
author_reputation1,676,739,286,318,667
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,815,396
net_rshares57,559,895,885
author_curate_reward""
vote details (2)
@macchiata ·
๐Ÿ˜‚ I just happen to start learning data science and this was the problem that actually got to me. So, I am glad to learn something new and partially solve the problem. Asking other helps would have been faster and I tried but I don't like it when I don't understand the whole thing ๐Ÿ˜„
๐Ÿ‘  
properties (23)
authormacchiata
permlinkre-livinguktaiwan-srrqk1
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3"}
created2025-02-16 09:04:54
last_update2025-02-16 09:04:54
depth2
children0
last_payout2025-02-23 09:04: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_length282
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,824,616
net_rshares0
author_curate_reward""
vote details (1)
@olujay ·
Cool! Maybe next thing we'll see is you automating the unfollow process with Python. I'd like to learn that.
properties (22)
authorolujay
permlinkre-macchiata-srrx8o
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-16 11:29:15
last_update2025-02-16 11:29:15
depth1
children1
last_payout2025-02-23 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_length108
author_reputation530,536,449,085,412
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,826,304
net_rshares0
@macchiata ·
hahahaha I'd like to learn that too but maybe in a million years before I can even do that
properties (22)
authormacchiata
permlinkre-olujay-srs5r6
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3"}
created2025-02-16 14:33:15
last_update2025-02-16 14:33:15
depth2
children0
last_payout2025-02-23 14: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_length90
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,829,156
net_rshares0
@promete0sz ·
$0.46
Muchachona did not know you have your knowledge in programming or at least that I understand, in my case I have not had the problem or inconvenience you mention, in fact I had to read several times to understand the problem that afflicts you for a long time haha.

With pleasure I vote for the proposal that seems to me something positive by where it is seen, that if I grasped it immediately by the solutions and advantages that it offers besides being able to arrive free to all if the proposal is approved so that they can solve this way their inconveniences.

To what I could conclude is that I have to read the hivesql documentation to adapt it to my needs using as base the elements that you have mentioned. It is striking the WHERE TOP SELECT etc haha, I got to see some programming in college and it is always striking the ways in which the programs place the terms to adapt the conditions and the program flows. That's what I could understand ๐Ÿ˜….... I think you drank many coffees while solving all this conflict ๐Ÿ˜ƒ

>Muchachona no sabรญa tienes tus conocimientos en programacion o al menos eso voy entendiendo, en mi caso no he tenido el problema o inconveniente que mencionas, de hecho tuve que leer varias veces para poder entender el problema que te aqueja desde hace buen tiempo jaja

>Con gusto voto por la propuesta que me parece algo positivo por donde se vea, eso si que lo capte inmediatamente por las soluciones y ventajas que ofrece ademรกs de poder llegar gratis a todos si la propuesta se aprueba para que puedan solucionar asรญ sus inconvenientes

>A lo que pude concluir es que tengo que leer la documentacion hivesql para adaptarlo a mis necesidades usando como base los elementos que haz mencionado. Llamativo lo de WHERE TOP SELECT etc jaja, llegue a ver algo de programaciรณn en la universidad y siempre son llamativas las maneras en que los programas colocan los terminos para uno poder adaptar las condiciones y fluya el programa. Es lo que pude entender ๐Ÿ˜….... pienso tomaste muchos cafes mientras resolvias todo este conflicto ๐Ÿ˜ƒ
๐Ÿ‘  , , , , ,
properties (23)
authorpromete0sz
permlinkre-macchiata-srqjr4
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-15 17:40:21
last_update2025-02-15 17:40:21
depth1
children3
last_payout2025-02-22 17:40:21
cashout_time1969-12-31 23:59:59
total_payout_value0.231 HBD
curator_payout_value0.231 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,054
author_reputation255,147,079,390,263
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,812,201
net_rshares1,070,597,714,921
author_curate_reward""
vote details (6)
@macchiata ·
It's basically we run a requirement in @lovesniper that account must be unfollowed after they get to rep 60 since that also indicates that they already familiarize themselves with the ecosystem.  So, for a long time, a lot of us did it manually and it gets tedious. We have to go through pages of pages while with that simple script, we can simply have list of name within mere seconds haha. The problem is definitely unique but again if you want to know a lot of data and wants to solve problems around HiveSQL is the start. 

I know we have some tools around like hive-now but it's alway good to learn something new and now I can know things that I really want to know rather than going to multiple websites to find certain things.So, I hope it gets funded hehe ๐Ÿ˜ƒ


You're definitely right, I had quite a bit of coffee hahaha and that's why I got this AHA moment to solve this problem that's been a while for me.
๐Ÿ‘  ,
properties (23)
authormacchiata
permlinksrqk67
categoryhive-155735
json_metadata{"users":["lovesniper"],"app":"hiveblog/0.1"}
created2025-02-15 17:49:33
last_update2025-02-15 17:49:33
depth2
children0
last_payout2025-02-22 17:49: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_length914
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,812,410
net_rshares22,781,941,711
author_curate_reward""
vote details (2)
@topcomment ·
<center>
**Your comment is upvoted by [@topcomment](https://peakd.com/@topcomment)**
<center>
**[Info](https://peakd.com/hive-148441/@topcomment/rewarding-meaningful-comments-with-topcomment) - [Support](https://peakd.com/hive/@topcomment/support-topcomment-a-delegation-and-earn-80percent-curation-rewards) - [Discord](https://discord.gg/u7ebA2QKCd)**
</center>
[![image.png](https://files.peakd.com/file/peakd-hive/topcomment/EpGRgMJ92JzvktbWphJhBiKrsNYoqLrXvTGH5yP9offkMeLLFZ7PrCbT1T4SfMDC5NS.png)](https://peakd.com/@topcomment) 
๐Ÿ‘  
properties (23)
authortopcomment
permlinkre-promete0sz-1739654832
categoryhive-155735
json_metadata"{"tags": ["hive-155735"], "app": "HiveDiscoMod"}"
created2025-02-15 21:27:12
last_update2025-02-15 21:27:12
depth2
children1
last_payout2025-02-22 21:27: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_length533
author_reputation7,519,979,968,003
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,816,276
net_rshares23,224,608,886
author_curate_reward""
vote details (1)
@promete0sz ·
Success to continue for more genuineness and good contribution to high quality content on the platform, this motivates to continue for Success ๐Ÿ˜Ž

>El Exito a seguir por mas genuinidad y buen aporte a los contenidos de gran calidad en la plataforma, esto motiva a seguir por el Exito ๐Ÿ˜Ž
properties (22)
authorpromete0sz
permlinkre-topcomment-srrb71
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-16 03:32:51
last_update2025-02-16 03:32:51
depth3
children0
last_payout2025-02-23 03:32: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_length284
author_reputation255,147,079,390,263
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,821,183
net_rshares0
@seki1 ·
$0.02
Love sniper hasn't been active for some time though.

I literally forgot about that app till now๐Ÿ˜‚๐Ÿ˜‚โœจ

Really don't remember it curating my works back then when I was a newbie nor did I follow it.

Or maybe it didn't curate my work because I didn't follow it?๐Ÿ˜‚
๐Ÿ‘  
properties (23)
authorseki1
permlinkre-macchiata-srrix9
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-16 06:20:00
last_update2025-02-16 06:20:00
depth1
children4
last_payout2025-02-23 06:20:00
cashout_time1969-12-31 23:59:59
total_payout_value0.012 HBD
curator_payout_value0.012 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length258
author_reputation152,465,402,379,985
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,822,900
net_rshares56,408,273,672
author_curate_reward""
vote details (1)
@macchiata ·
It's not because you don't follow it rather we through @lovesniper should follow the new user.  We curate our feed and has certain rules as well. I am sure you've been curated by us, I've seen your name a couple of time ๐Ÿ˜Š
๐Ÿ‘  
properties (23)
authormacchiata
permlinkre-seki1-srrqju
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3"}
created2025-02-16 09:04:48
last_update2025-02-16 09:04:48
depth2
children3
last_payout2025-02-23 09:04: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_length221
author_reputation1,384,980,362,611,795
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,824,615
net_rshares0
author_curate_reward""
vote details (1)
@seki1 ·
Hmmm

Okay๐Ÿ˜‚๐Ÿ˜‚

So you're unfollowing them because you're not part of the curation team again or,?..
properties (22)
authorseki1
permlinkre-macchiata-srrr8s
categoryhive-155735
json_metadata{"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]}
created2025-02-16 09:19:42
last_update2025-02-16 09:19:42
depth3
children2
last_payout2025-02-23 09:19: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_length98
author_reputation152,465,402,379,985
root_title"I Just Learned How to Sort Following List by Reputation With HiveSQLโ€”Feels Silly but Exciting!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id140,824,781
net_rshares0