Post AQCMfjnwheW3TCc796 by matty@nicecrew.digital
(DIR) More posts by matty@nicecrew.digital
(DIR) Post #AQC7q93WAyenMuOzFg by iamtakingiteasy@eientei.org
2022-12-02T11:21:46.119153Z
5 likes, 3 repeats
Soap opera fandom stats.with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble)(\W|$)' and inserted_at >= '2022-11-01' order by id desc) select instance, count(*) from s group by instance order by count desc; instance | count -------------------------------+------- chudbuds.lol | 1650 poa.st | 693 nicecrew.digital | 145 freespeechextremist.com | 139 bae.st | 77 shitposter.club | 60 posting.lolicon.rocks | 45 detroitriotcity.com | 37 varishangout.net | 30 sleepy.cafe | 29 shitpost.cloud | 27 fedi.pawlicker.com | 20 seal.cafe | 20 noagendasocial.com | 18 social.xenofem.me | 16 mastodon.social | 16 cum.salon | 15 honkwerx.tech | 15 mugicha.club | 14 comfyboy.club | 14 rdrama.cc | 14 shortstackran.ch | 14 freecumextremist.com | 14 beefyboys.win | 13 cawfee.club | 13 miss.mouse.services | 13 pleroma.nobodyhasthe.biz | 11 outpoa.st | 11 social.fedcast.ch | 10 strelizia.net | 10 leafposter.club | 10 pirateradio.social | 10 eveningzoo.club | 9 qoto.org | 9 gameliberty.club | 9 collapsitarian.io | 9 hidamari.apartments | 8 sperg.city | 7 gearlandia.haus | 6 bozgor.org | 5 sneed.social | 5 respublicae.eu | 5 mstdn.social | 5 gleasonator.com | 5 blob.cat | 4 101010.pl | 4 pl.kitsunemimi.club | 4 mastodon.uy | 4 social.anthro.cc | 4 ryona.agency | 4 refusal.biz | 4 social.horrorhub.club | 4
(DIR) Post #AQC92t7Iqd7teZoRVo by lewdthewides@hidamari.apartments
2022-12-02T11:35:06.417227Z
0 likes, 0 repeats
@iamtakingiteasy >1650What a shit instance
(DIR) Post #AQCArCP7VnffuChUUS by rootbsd@rojogato.com
2022-12-02T11:55:27.120330Z
0 likes, 0 repeats
@Prude @iamtakingiteasy Rojogato didn't even make the list, winning! :justright: Even though Im guilty of promoting Luke Smith here and there 😤
(DIR) Post #AQCArhRg6L8YB78THU by iamtakingiteasy@eientei.org
2022-12-02T11:55:39.619259Z
0 likes, 0 repeats
@Prude I haven't been following even single episode of this drama. If you have a more complete list - I can adjust the selector.
(DIR) Post #AQCCMjGRUNOUkaEwZE by Prude@beefyboys.win
2022-12-02T11:59:48.133415Z
0 likes, 0 repeats
Well, if it's just about a particular subset of drama, many will have nothing to do with it. Just correcting myself that it's not the full picture re: e-celeb dickriding since guys like Kike Enoch (+NJP orbiters) and Borzoi and many others aren't there, but it makes sense that they wouldn't be if this is about some particular thing.
(DIR) Post #AQCCMjgfuqNU3wVtSK by iamtakingiteasy@eientei.org
2022-12-02T12:12:27.121689Z
0 likes, 0 repeats
@Prude It is not particular, I just put whichever I recalled from those fags mentioning all the time recently. Also you might need to spell them out, I can only find the exact spelling with the help of search otherwise, I really have no investment in any of those names and wouldn’t ever known them if not for them being repeated ad nauseam. with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble|borzoi|mike|enoch)(\W|$)' and inserted_at >= '2022-11-01' order by id desc) select instance, count(*) from s group by instance order by count desc; instance | count -------------------------------+------- chudbuds.lol | 1695 poa.st | 890 nicecrew.digital | 228 freespeechextremist.com | 171 bae.st | 92 shitposter.club | 72 posting.lolicon.rocks | 49 detroitriotcity.com | 45 sleepy.cafe | 37 varishangout.net | 35 mastodon.social | 31 mugicha.club | 29 shitpost.cloud | 28 seal.cafe | 26 freecumextremist.com | 25 beefyboys.win | 23 noagendasocial.com | 22 honkwerx.tech | 20 fedi.pawlicker.com | 20 cum.salon | 19 comfyboy.club | 19 pleroma.nobodyhasthe.biz | 19 fosstodon.org | 19 pirateradio.social | 18 shortstackran.ch | 18 outpoa.st | 17 social.xenofem.me | 16 techhub.social | 16 cawfee.club | 15 qoto.org | 15 rdrama.cc | 15 miss.mouse.services | 13 strelizia.net | 12 respublicae.eu | 12 eveningzoo.club | 12 mstdn.social | 11 collapsitarian.io | 11 leafposter.club | 11 social.fedcast.ch | 10 refusal.biz | 10 social.horrorhub.club | 10 gleasonator.com | 9 gameliberty.club | 9 gearlandia.haus | 9 hidamari.apartments | 8 mastodonapp.uk | 8 sneed.social | 8 ravenation.club | 7 bozgor.org | 7 sperg.city | 7 udongein.xyz | 7 lor.sh | 6
(DIR) Post #AQCCywojXzRTmxVHPs by iamtakingiteasy@eientei.org
2022-12-02T12:19:18.413658Z
0 likes, 0 repeats
@Kallanae @Prude Jim does seem to clash with some local poast user. Unless they managed to acquire one of their idols for entertainment.
(DIR) Post #AQCDPpJrX4FaLwsfEe by Kallanae@beefyboys.win
2022-12-02T12:19:52.993440Z
0 likes, 0 repeats
he has a presence on both but mostly posts on poast i think
(DIR) Post #AQCDPpohgOv7tbJIJ6 by iamtakingiteasy@eientei.org
2022-12-02T12:24:14.544131Z
1 likes, 0 repeats
@Kallanae @Prude Inclusion of active account skews statistic in absolute numbers due to how mentions work in threads, but relative standings are still the same.with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble|borzoi|mike|enoch|metokur|jim)(\W|$)' and inserted_at >= '2022-11-01' order by id desc) select instance, count(*) from s group by instance order by count desc limit 50; instance | count --------------------------+------- chudbuds.lol | 7564 poa.st | 2109 nicecrew.digital | 467 freespeechextremist.com | 279 shitposter.club | 181 bae.st | 163 seal.cafe | 101 detroitriotcity.com | 82 sleepy.cafe | 80 shitpost.cloud | 77 varishangout.net | 67 posting.lolicon.rocks | 63 shortstackran.ch | 44 pleroma.nobodyhasthe.biz | 42 mugicha.club | 39 eveningzoo.club | 39 noagendasocial.com | 35 mastodon.social | 34 freecumextremist.com | 32 leafposter.club | 30 beefyboys.win | 30 honkwerx.tech | 29 gameliberty.club | 27 cawfee.club | 26 fedi.pawlicker.com | 25 outpoa.st | 24 cum.salon | 23 pirateradio.social | 22 respublicae.eu | 22 comfyboy.club | 22 fosstodon.org | 20 social.xenofem.me | 20 rdrama.cc | 19 bozgor.org | 18 eientei.org | 18 strelizia.net | 18 kurosawa.moe | 17 miss.mouse.services | 16 techhub.social | 16 qoto.org | 15 mstdn.social | 14 collapsitarian.io | 13 gearlandia.haus | 12 gleasonator.com | 12 masochi.st | 12 sneed.social | 12 leadslinger.org | 11 social.horrorhub.club | 11 springbo.cc | 11 refusal.biz | 11(50 rows)
(DIR) Post #AQCGs4OPNpPf4aALxo by NEETzsche@iddqd.social
2022-12-02T13:02:58.032280Z
0 likes, 0 repeats
Now divide the number of e-celeb name drops by the total number of posts on that instance. This way we can consider that more active instances would naturally mention any topic more than less active ones.
(DIR) Post #AQCJRlp06igXoDktW4 by dj@rojogato.com
2022-12-02T13:31:48.604679Z
1 likes, 0 repeats
@rootbsd @Prude @iamtakingiteasy That's because I'm too embarrassed to post about my favourite vtubers and tiddy twitchers. 🥴
(DIR) Post #AQCL1KjqNZloBurgn2 by iamtakingiteasy@eientei.org
2022-12-02T13:49:27.517955Z
1 likes, 1 repeats
@NEETzsche @Kallanae @Prude With the same top:with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble|borzoi|mike|enoch|metokur|jim)(\W|$)' and inserted_at >= '2022-11-01'), top as (select instance, count(*) from s group by instance limit 50), total as (select instance, count(*) from top join objects on regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') = instance and inserted_at >= '2022-11-01' group by instance) select top.instance, round((top.count::numeric / total.count::numeric)*100, 2) as fraction, top.count as top, total.count as total from top join total on top.instance = total.instance order by fraction desc; instance | fraction | top | total ------------------------+----------+------+-------- better.boston | 15.38 | 2 | 13 docviper.de | 14.29 | 1 | 7 blog.dumango.com | 13.33 | 2 | 15 bookwor.ms | 10.00 | 1 | 10 anthro.cc | 9.09 | 1 | 11 chudbuds.lol | 7.92 | 7565 | 95570 chancellor.social | 4.17 | 1 | 24 blimey.social | 4.00 | 1 | 25 calobar.club | 3.85 | 1 | 26 brighteon.social | 3.33 | 1 | 30 cztwitter.cz | 3.23 | 1 | 31 bozgor.org | 3.04 | 18 | 592 angrytoday.com | 2.50 | 1 | 40 adhd.energy | 2.50 | 1 | 40 detroitriotcity.com | 1.37 | 82 | 5965 asimon.org | 1.29 | 4 | 309 astrodon.social | 1.10 | 1 | 91 13bells.com | 1.09 | 3 | 276 akm.longyap.name.my | 0.95 | 1 | 105 cloudisland.nz | 0.94 | 1 | 106 crlf.ninja | 0.85 | 6 | 710 cyberstorm.one | 0.81 | 4 | 492 dice.camp | 0.78 | 1 | 128 comfyboy.club | 0.73 | 22 | 2994 acidrow.com | 0.68 | 1 | 146 blop.social | 0.60 | 1 | 166 climatejustice.social | 0.56 | 1 | 178 bajax.us | 0.53 | 2 | 377 cheeseburger.social | 0.52 | 1 | 191 eeeeeeeee.eu | 0.51 | 1 | 197 collapsitarian.io | 0.50 | 13 | 2583 akkoma.thejar.club | 0.48 | 1 | 209 cum.salon | 0.47 | 23 | 4890 bitcoinhackers.org | 0.40 | 1 | 248 bikeshed.party | 0.32 | 3 | 937 clubcyberia.co | 0.29 | 11 | 3740 amala.schwartzwelt.xyz | 0.28 | 2 | 718 beefyboys.win | 0.25 | 30 | 11940 cawfee.club | 0.19 | 26 | 13622 blob.cat | 0.18 | 4 | 2218 eientei.org | 0.16 | 19 | 12251 chaos.social | 0.15 | 3 | 1952 bae.st | 0.15 | 163 | 107115 ap.maladaptive.art | 0.14 | 1 | 712 c.im | 0.11 | 2 | 1879 djsumdog.com | 0.10 | 1 | 1046 101010.pl | 0.10 | 4 | 4003 cdrom.tokyo | 0.08 | 3 | 3573 csdisaster.club | 0.07 | 1 | 1414 anonsys.net | 0.07 | 1 | 1342(50 rows)And excluding those instances that had less than 100 statuses federated throughout the past month:with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble|borzoi|mike|enoch|metokur|jim)(\W|$)' and inserted_at >= '2022-11-01'), top as (select instance, count(*) from s group by instance), total as (select instance, count(*) from top join objects on regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') = instance and inserted_at >= '2022-11-01' group by instance) select top.instance, round((top.count::numeric / total.count::numeric)*100, 2) as fraction, top.count as top, total.count as total from top join total on top.instance = total.instance where total.count > 100 order by fraction desc limit 50; instance | fraction | top | total --------------------------+----------+------+-------- techhub.social | 8.29 | 16 | 193 chudbuds.lol | 7.92 | 7565 | 95573 sperg.city | 7.41 | 8 | 108 sneed.social | 6.49 | 12 | 185 leadslinger.org | 5.82 | 11 | 189 toad.social | 5.00 | 7 | 140 shitpost.cloud | 3.55 | 77 | 2170 kurosawa.moe | 3.20 | 17 | 532 bozgor.org | 3.04 | 18 | 592 springbo.cc | 2.67 | 11 | 412 sneed.vip | 2.59 | 3 | 116 miss.mouse.services | 2.14 | 16 | 746 poa.st | 1.90 | 2114 | 111213 free.burningpixel.net | 1.83 | 4 | 219 fedi.pawlicker.com | 1.73 | 25 | 1445 universeodon.com | 1.48 | 3 | 203 pl.kitsunemimi.club | 1.40 | 6 | 428 pleroma.nobodyhasthe.biz | 1.40 | 42 | 3004 mastodon.nzoss.nz | 1.37 | 2 | 146 detroitriotcity.com | 1.37 | 82 | 5965 asimon.org | 1.29 | 4 | 309 muh.wang | 1.28 | 4 | 312 pl.polaris-1.work | 1.19 | 5 | 421 13bells.com | 1.09 | 3 | 276 sleepy.cafe | 1.02 | 80 | 7866 seal.cafe | 1.01 | 101 | 9976 sully.site | 0.97 | 1 | 103 akm.longyap.name.my | 0.95 | 1 | 105 cloudisland.nz | 0.94 | 1 | 106 outpoa.st | 0.93 | 24 | 2579 honkwerx.tech | 0.92 | 29 | 3143 posting.lolicon.rocks | 0.91 | 63 | 6961 toad.city | 0.89 | 1 | 112 pkteerium.xyz | 0.89 | 4 | 447 genderheretics.xyz | 0.89 | 1 | 112 fosstodon.org | 0.86 | 20 | 2317 crlf.ninja | 0.85 | 6 | 710 masochi.st | 0.85 | 12 | 1415 pooper.social | 0.85 | 1 | 117 cyberstorm.one | 0.81 | 4 | 492 hermit.cafe | 0.78 | 2 | 258 dice.camp | 0.78 | 1 | 128 libretooth.gr | 0.76 | 1 | 132 federated.fun | 0.76 | 3 | 394 laserdisc.party | 0.74 | 1 | 135 pirateradio.social | 0.73 | 22 | 3015 comfyboy.club | 0.73 | 22 | 2994 geofront.rocks | 0.72 | 3 | 414 loma.ml | 0.71 | 6 | 849 sueden.social | 0.71 | 1 | 141(50 rows)
(DIR) Post #AQCLYrVtXkuxOhKPBY by NEETzsche@iddqd.social
2022-12-02T13:55:31.668599Z
0 likes, 0 repeats
@iamtakingiteasy @Kallanae @Prude Excellent work. Thank up
(DIR) Post #AQCLZDuoFnv2sL9c4e by NEETzsche@iddqd.social
2022-12-02T13:55:35.784204Z
1 likes, 0 repeats
@iamtakingiteasy @Kallanae @Prude you*
(DIR) Post #AQCMGbgdkQw53NDHSC by iamtakingiteasy@eientei.org
2022-12-02T14:03:26.482474Z
1 likes, 0 repeats
@NEETzsche @Kallanae @Prude And for reference, original [absolute] top with percentages attached. with s as (select inserted_at::date as day, regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') as instance from objects where data->>'content' ~* '(\W|^)(ralph|ethan|gunt|nick|milo|yiann?opou?lou?s|fuentes|bibble|borzoi|mike|enoch|metokur|jim)(\W|$)' and inserted_at >= '2022-11-01'), top as (select instance, count(*) from s group by instance), total as (select instance, count(*) from top join objects on regexp_replace(data->>'actor', 'https://([^/]*)/.*', '\1') = instance and inserted_at >= '2022-11-01' group by instance) select top.instance, round((top.count::numeric / total.count::numeric)*100, 2) as fraction, top.count as top, total.count as total from top join total on top.instance = total.instance order by top.count desc limit 50; instance | fraction | top | total --------------------------+----------+------+-------- chudbuds.lol | 7.92 | 7566 | 95586 poa.st | 1.90 | 2114 | 111244 nicecrew.digital | 0.59 | 468 | 78916 freespeechextremist.com | 0.51 | 280 | 55079 shitposter.club | 0.34 | 182 | 53440 bae.st | 0.15 | 163 | 107126 seal.cafe | 1.01 | 101 | 9977 detroitriotcity.com | 1.37 | 82 | 5965 sleepy.cafe | 1.02 | 80 | 7867 shitpost.cloud | 3.55 | 77 | 2170 varishangout.net | 0.16 | 67 | 42407 posting.lolicon.rocks | 0.90 | 63 | 6964 shortstackran.ch | 0.35 | 44 | 12513 pleroma.nobodyhasthe.biz | 1.40 | 42 | 3007 eveningzoo.club | 0.16 | 39 | 24791 mugicha.club | 0.45 | 39 | 8694 noagendasocial.com | 0.45 | 35 | 7862 mastodon.social | 0.33 | 34 | 10412 freecumextremist.com | 0.22 | 32 | 14281 leafposter.club | 0.57 | 30 | 5218 beefyboys.win | 0.25 | 30 | 11947 honkwerx.tech | 0.92 | 29 | 3144 gameliberty.club | 0.37 | 27 | 7353 cawfee.club | 0.19 | 26 | 13625 fedi.pawlicker.com | 1.73 | 25 | 1445 outpoa.st | 0.93 | 24 | 2580 cum.salon | 0.47 | 23 | 4893 pirateradio.social | 0.73 | 22 | 3015 respublicae.eu | 0.18 | 22 | 12409 comfyboy.club | 0.73 | 22 | 2994 social.xenofem.me | 0.42 | 20 | 4784 eientei.org | 0.16 | 20 | 12261 fosstodon.org | 0.86 | 20 | 2317 bozgor.org | 3.19 | 19 | 596 rdrama.cc | 0.54 | 19 | 3518 strelizia.net | 0.57 | 18 | 3152 kurosawa.moe | 3.20 | 17 | 532 miss.mouse.services | 2.14 | 16 | 746 techhub.social | 8.29 | 16 | 193 qoto.org | 0.23 | 15 | 6413 mstdn.social | 0.43 | 14 | 3234 gleasonator.com | 0.29 | 13 | 4541 collapsitarian.io | 0.50 | 13 | 2585 gearlandia.haus | 0.21 | 12 | 5845 masochi.st | 0.85 | 12 | 1415 sneed.social | 6.49 | 12 | 185 misskey.cf | 0.38 | 11 | 2926 social.horrorhub.club | 0.48 | 11 | 2270 leadslinger.org | 5.82 | 11 | 189 springbo.cc | 2.67 | 11 | 412(50 rows)
(DIR) Post #AQCMQ3I6U9V3GyExZA by matty@nicecrew.digital
2022-12-02T14:03:30.199565Z
1 likes, 0 repeats
I am a little upset we rank that high on this list. I am going to ban everyone now.
(DIR) Post #AQCMcLaCIojxTkZAYq by Prude@beefyboys.win
2022-12-02T13:57:47.935993Z
2 likes, 0 repeats
thank up 👆 🙏 😤
(DIR) Post #AQCMfjKWT2ypzwqcHg by d0c40r0@nicecrew.digital
2022-12-02T14:04:40.365509Z
0 likes, 0 repeats
What does “soap opera fandom stats” even mean
(DIR) Post #AQCMfjnwheW3TCc796 by matty@nicecrew.digital
2022-12-02T14:05:26.294274Z
1 likes, 0 repeats
I think it's just how many times those keywords were mentioned over the course of the month.
(DIR) Post #AQCNG2qFOurUwC0Eka by iamtakingiteasy@eientei.org
2022-12-02T14:14:32.827661Z
1 likes, 0 repeats
@matty Your percentage is still below 1, which seem to be around average levels. You can have comfort of nicecrew being more than 13 times better than chudbuds, however low that bar may be.
(DIR) Post #AQCNpfVNdviezAEGPY by iamtakingiteasy@eientei.org
2022-12-02T14:20:57.732599Z
0 likes, 0 repeats
@d0c40r0 @matty The kind old ladies tend to watch on their retirement, discussing nonsensical plot twists with each other over the course of decades those shows tend to run (probably betting on previous audience to expire before the rerun), but with slightly different cast and setting.
(DIR) Post #AQCPkyanRuDge0eXJY by FarcryFuhrer@poa.st
2022-12-02T14:42:33.249491Z
0 likes, 0 repeats
@matty @iamtakingiteasy But ncd has the hottest most flirty women it wouldn’t be the same without them.
(DIR) Post #AQCcFVBg1eMdsBE2e8 by Monsignor_DickFace@poa.st
2022-12-02T17:02:31.873188Z
0 likes, 0 repeats
@iamtakingiteasy Jesus Christ....chudbuds seems pretty fucking gay
(DIR) Post #AQEzNV1lBsfCxII09Y by PhenomX6@fedi.pawlicker.com
2022-12-03T20:31:02.589009Z
0 likes, 0 repeats
@iamtakingiteasy I'm sure less people would be talking about Nick if he didn't hitch himself to a schizophrenic rapper turning into a Poastie.