Conversation

Notices

1.  (mint@ryona.agency)'s status on Sunday, 18-Feb-2024 05:44:37 JST 

   • Jeff Cliff
   • :btrfly: anime graf mays 🛰️🪐
   • NEETzsche
   • Himbo Techbro
   • :p:
   @NEETzsche @p @r000t @graf @jeffcliff All /federation/actors/ are Funkwhate actors which also use that Audio type.
   • NEETzsche (neetzsche@iddqd.social)'s status on Sunday, 18-Feb-2024 05:58:25 JST NEETzsche

     in reply to

     • Jeff Cliff
     • :btrfly: anime graf mays 🛰️🪐
     • Himbo Techbro
     • :p:

     Just realized you can build top ten lists with SQL. Here's one for the top ten artists of all time:

     pleroma=> SELECT COUNT(*) "count", data->>'artist' "artist" FROM objects WHERE data->>'type' = 'Audio' AND LENGTH(TRIM(COALESCE(data->>'artist', ''))) > 0 GROUP BY data->>'artist' ORDER BY COUNT(*) DESC LIMIT 10; count | artist -------+------------------ 469 | OT the Real 440 | James Kibbie 278 | Jedi Mind Tricks 247 | Vinnie Paz 240 | e00 220 | Rippingtons 209 | Aesop Rock 204 | 2023 193 | Taylor Swift 193 | Outerspace (10 rows)
      likes this.