Conversation
Notices
-
abjectio (knuthollund)'s status on Tuesday, 05-Jan-2016 22:43:07 CET abjectio 1427 of 3528 users on !quitterno , have never sent a notice. :( !gs - Christel T. likes this.
-
vinzv (vinzv)'s status on Tuesday, 05-Jan-2016 22:53:26 CET vinzv @knuthollund What SQL query did you use to find out? -
abjectio (knuthollund)'s status on Tuesday, 05-Jan-2016 22:56:40 CET abjectio @vinzv first count users - select count(*) from user; then - select id,nickname,modified from user where id not in (select profile_id from notice); Roland Häder and vinzv like this.Roland Häder repeated this. -
abjectio (knuthollund)'s status on Tuesday, 05-Jan-2016 22:58:51 CET abjectio @vinzv Number of users sendt less than e.g. 200 queets - select count(*) from user where (select count(notice.id) from notice where notice.profile_id = user.id) < 200; vinzv likes this. -
vinzv (vinzv)'s status on Tuesday, 05-Jan-2016 23:03:27 CET vinzv @knuthollund Thanks! So for !gnusocialde it's 209 accounts of total 529 were never active. Nearly the same percentage as on quitter.no (39% v 40%). Benedikt Geißler likes this.Benedikt Geißler repeated this. -
mcscx (mcscx)'s status on Tuesday, 05-Jan-2016 23:15:49 CET mcscx @knuthollund @vinzv There's a large number of (semi) inactive accts on Twitter too. You can check w/ twitter\.com/<randomname> abjectio likes this. -
abjectio (knuthollund)'s status on Tuesday, 05-Jan-2016 23:17:05 CET abjectio @mcscx :-) True - will always be on any #some network. /cc @vinzv -
mcscx (mcscx)'s status on Tuesday, 05-Jan-2016 23:18:01 CET mcscx @knuthollund @vinzv for example: twitter\.com/hannes stopped tweeting in 2014 and twitter\.com/hannes1 has just 2 tweets abjectio likes this. -
mcscx (mcscx)'s status on Tuesday, 05-Jan-2016 23:26:08 CET mcscx @knuthollund @vinzv I just checked twitter\.com/hannes2 … hannes10: each has 0-2 tweets,only exception being hannes5 w/ total of 23 tweets -
resumer (resumer)'s status on Wednesday, 06-Jan-2016 22:12:52 CET resumer @knuthollund wow, that i call a lot of shy people. or do you think we aren't enough of a safe space? https://quitter.no/url/94871