Untitled attachment

Notices where this attachment appears

1. Embed this notice
    (mint@ryona.agency)'s status on Thursday, 17-Apr-2025 23:50:37 JST 

   in reply to
   @dsm $ doas -u postgres psql -d agency -At -c "select data->>'actor' from activities where data->>'type
   ' = 'Listen' order by id asc;" | sort | uniq -c | sort -rn
   27336 https://bae.st/users/p
   21462 https://shitposter.world/users/p
   10292 https://shitposter.club/users/jeffcliff
   6697 https://iddqd.social/users/sundowner
   6580 https://thechimp.zone/users/thegreatape
   6247 https://iddqd.social/users/NEETzsche
   3686 https://asphodel.rip/users/Vaghrad
   2611 https://shitposter.club/users/p
   655 https://breastmilk.club/users/marine
   509 https://iddqd.social/users/ChristopherBRobin
   302 https://clubcyberia.co/users/Inginsub
   192 https://cawfee.club/users/cine
   174 https://bikeshed.party/users/feld
   104 https://friedcheese.us/users/feld
   89 https://clubcyberia.co/users/cassidyclown
   55 https://ryona.agency/users/mint
   31 https://clubcyberia.co/users/neko
   17 https://ryona.agency/users/lauralt
   15 https://bae.st/users/nosleep
   13 https://shitposter.club/users/Moon
   10 http://rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion/users/khayyam
   8 https://ryona.agency/users/FrailLeaf
   4 https://ryona.agency/users/cutemaxxer
   4 https://bae.st/users/Pawlicker
   3 https://shitposter.club/users/Bajax
   3 https://boymoder.biz/users/nukie
   2 https://social.singing.dog/users/Coyote
   2 https://cum.salon/users/chog9
   1 https://shitposter.world/users/sun
   1 https://ryona.agency/users/aosoth
   Checks out.
2. Embed this notice
   NEETzsche (neetzsche@iddqd.social)'s status on Sunday, 18-Feb-2024 05:40:40 JST NEETzsche

   in reply to

   I'm getting mogged by @jeffcliff in terms of scrobble count on this instance as well:

   pleroma=> SELECT COUNT(*), data->>'actor' FROM objects WHERE data->>'type' = 'Audio' GROUP BY data->>'actor' ORDER BY COUNT(*) DESC; count | actor -------+-------------------------------------------------------------------------------- 6700 | https://shitposter.club/users/jeffcliff 5220 | https://iddqd.social/users/NEETzsche 3395 | https://iddqd.social/users/sundowner 2172 | https://thechimp.zone/users/thegreatape 1715 | https://iddqd.social/users/ChristopherBRobin 618 | https://pleroma.breizh.pm/users/breizh 517 | https://breastmilk.club/users/marine 313 | https://clubcyberia.co/users/Inginsub 149 | https://iddqd.social/users/nolasco 110 | https://pl.fediverse.pl/users/mkljczk 89 | https://clubcyberia.co/users/cassidyclown 34 | https://baleafunk.eus/federation/actors/memoriahisterikoa 32 | https://desuposter.club/users/neko 31 | https://baleafunk.eus/federation/actors/beranduegi 27 | https://ryona.agency/users/mint 17 | https://baleafunk.eus/federation/actors/argiarenpodcastak 13 | https://baleafunk.eus/federation/actors/egonarria 11 | https://shitposter.club/users/Moon 10 | https://funkwhale.it/federation/actors/compilation 10 | https://baleafunk.eus/federation/actors/btn 9 | https://bae.st/users/nosleep 9 | https://baleafunk.eus/federation/actors/borroka_maitasun_eta_traizio_istorioak 7 | https://sound.manalejandro.com/federation/actors/misc 7 | https://ryona.agency/users/FrailLeaf 7 | https://baleafunk.eus/federation/actors/larrun 6 | https://baleafunk.eus/federation/actors/menda_bikoitza 6 | https://open.audio/federation/actors/umlautsdiary 5 | https://sound.manalejandro.com/federation/actors/electroniccut 4 | https://funkwhale.it/federation/actors/librepodcast 3 | https://posting.lolicon.rocks/users/lain 3 | https://boymoder.biz/users/nukie 3 | https://baleafunk.eus/federation/actors/btn_senorak_edition 3 | https://funkwhale.it/federation/actors/danieletech 2 | https://funkwhale.it/federation/actors/seunribellespento 2 | https://open.audio/federation/actors/kde_express 1 | https://open.audio/federation/actors/podcastdec3po 1 | https://open.audio/federation/actors/predigergemeinde 1 | https://open.audio/federation/actors/umlautsareoverestimated 1 | https://zik.goe.land/federation/actors/japprends_le_breton 1 | https://pleroma.8777.ch/users/twl 1 | https://am.pirateradio.social/federation/actors/28Komma2Prozent 1 | https://baleafunk.eus/federation/actors/hodeiaezdaexistitzen 1 | https://baleafunk.eus/federation/actors/astekarikoak 1 | https://fw.ponychord.rocks/federation/actors/regex_channel 1 | https://gleasonator.com/users/NEETzsche 1 | https://kirche.funkwhale-host.de/federation/actors/sonntagsandacht 1 | https://open.audio/federation/actors/agafnd_electronic 1 | https://open.audio/federation/actors/agafndimprovisation 1 | https://open.audio/federation/actors/endegelaende 1 | https://open.audio/federation/actors/FutureOnAir 1 | https://open.audio/federation/actors/gurusofcomedy 1 | https://open.audio/federation/actors/nvdl_podcast
3. Embed this notice
    (mint@ryona.agency)'s status on Sunday, 18-Feb-2024 05:09:16 JST 

   in reply to
   @p @NEETzsche @r000t @graf $ doas -u postgres psql -d pleroma -At -c "select data->>'actor' from objects where data->>'type' = 'Audio' order by id asc;" | sort | uniq -c | sort -rn
   6763 https://shitposter.club/users/jeffcliff
   5172 https://iddqd.social/users/NEETzsche
   2158 https://thechimp.zone/users/thegreatape
   894 https://iddqd.social/users/sundowner
   517 https://breastmilk.club/users/marine
   301 https://clubcyberia.co/users/Inginsub
   89 https://clubcyberia.co/users/cassidyclown
   53 https://iddqd.social/users/ChristopherBRobin
   27 https://ryona.agency/users/mint
   11 https://shitposter.club/users/Moon
   11 https://bae.st/users/nosleep
   7 https://ryona.agency/users/lauralt
   7 https://ryona.agency/users/FrailLeaf
   4 https://ryona.agency/users/cutemaxxer
   3 https://shitposter.club/users/Bajax
   3 https://boymoder.biz/users/nukie
   3 http://rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion/users/khayyam
   2 https://social.singing.dog/users/Coyote
   2 https://cum.salon/users/chog9
   1 https://bae.st/users/Pawlicker
   Quite a few people use them, it looks like. Obviously this stat is limited to what I have here on Agency, and most of the federation here goes through side channels (relays, etc) so there isn't many activities that aren't plain posts. Some older instance would have more considering scrobbles has been around for years before Neetzsche added frontend support for them.