I don't know why this hasn't been done before but sort of inspired by the high volume of posts 83219 is getting (I can't imagine why) I present the top threads by post count and average post count per day.

Columns are thread, post count, average post count per day.
As usual test, spam and free are excluded. text also got excluded because of P82876.

[bold: Top 20 threads by post count.]
[bold: Ordered by post count:]
P3710 1000 1.91
P2781 1000 4.08
P33533 756 2.15
P41883 700 2.17
P5478 674 1.19
P19156 632 1.33
P83219 622 36.38
P35216 573 2.57
P6773 551 2.61
P2203 532 0.86
P11248 468 0.86
P7244 419 0.75
P69735 398 4.40
P38989 396 1.17
P24238 294 0.97
P78017 273 10.66
P1 271 0.32
P5836 263 0.54
P56866 261 7.17
P63531 238 2.56

[bold: Ordered by average post count per day:]
P83219 622 36.38
P78017 273 10.66
P56866 261 7.17
P69735 398 4.40
P2781 1000 4.08
P6773 551 2.61
P35216 573 2.57
P63531 238 2.56
P41883 700 2.17
P33533 756 2.15
P3710 1000 1.91
P19156 632 1.33
P5478 674 1.19
P38989 396 1.17
P24238 294 0.97
P2203 532 0.86
P11248 468 0.86
P7244 419 0.75
P5836 263 0.54
P1 271 0.32

[bold: Top 20 threads by average post count per day (with > 50 posts).]
[bold: Ordered by post count:]
P83219 622 36.38
P78017 273 10.66
P47602 198 32.15
P82560 168 83.15
P3066 116 15.35
P76430 106 15.78
P2652 106 14.54
P5012 90 31.7
P73864 77 18.59
P79087 76 12.45
P32203 76 11.68
P51396 71 11.47
P51908 69 22.89
P85583 63 8.52
P51404 63 21.02
P33015 63 12.87
P76186 59 22.34
P32827 59 14.82
P42557 53 8.77
P10486 51 28.18

[bold: Ordered by average post count per day:]
P82560 168 83.15
P83219 622 36.38
P47602 198 32.15
P5012 90 31.7
P10486 51 28.18
P51908 69 22.89
P76186 59 22.34
P51404 63 21.02
P73864 77 18.59
P76430 106 15.78
P3066 116 15.35
P32827 59 14.82
P2652 106 14.54
P33015 63 12.87
P79087 76 12.45
P32203 76 11.68
P51396 71 11.47
P78017 273 10.66
P42557 53 8.77
P85583 63 8.52

<sending ♥♥♥♥ to aidorufag
:3

Now post the code you used to do this with.

P86402
No homo.

P86403
>code
select * from (select 'P'||thread, count(*), round(count(*)/cast(max(date)-min(date) as real)*3600*24, 2) from posts join threads using (thread) where board not in ('spam', 'test', 'free', 'text') group by thread order by 2 desc limit 20) order by 2 desc, 1 desc;
select * from (select 'P'||thread, count(*), round(count(*)/cast(max(date)-min(date) as real)*3600*24, 2) from posts join threads using (thread) where board not in ('spam', 'test', 'free', 'text') group by thread having count(*) > 50 order by 3 desc limit 20) order by 3 desc, 1 desc;

btw, has soymin finally completed his endonigger transition?
I see that his janny bot no longer deletes cp links on sight and he takes a while to do it.

P86406
>A copy of the database, updated every 10 minutes, is at /Data/board.sql.gz.
Right. How do I collect all junior idol like this?

I was driving today and thinking about how I want to kiss a JI's sweet sexy legs. Then I find this thread. Well done, idoru

your waifu is basically a shitskin

even brazillian waifus are better than this shit tier asian

>even brazillian waifus are better than this shit tier asian

agreed

P86401

>As usual test, spam and free are excluded.

ok, retard. Then this thread is a waste. I ignored it when I first saw it btw.

P86496
Nothing of value is lost in those boards. /test/ is duplicates, /spam/ is spam and /free/ hasn't been used by anyone relevant since the birth of the site.

P86408
To answer my own question, P86405 has been up for more than a day so I guess he has.

P86435
>how I want to kiss a JI's sweet sexy legs.
Don't we all?

P86471
>Nooooooo her skin's RGB absorbs too much light, reeeeee.

P86474
Images for ants.

P86496
>I ignored it when I first saw it btw.
Yet you couldn't resist giving me a (You) :^).

P86550
I doubt it's a legitimate complaint.

P86554
qt like in your pic sits next to you and wants you to rest your head on her lap after a long day. your actions?

P86555
What kind of question is that?
Accept it of course [spoiler: while also having a raging boner wanting to bury my face in those thighs or tummy].
[spoiler: Now, if you ask me about the current world, probably panic].

./database.lua:89: not an error
stack traceback:
[C]: in function 'error'
./database.lua:89: in function 'transaction'
/srv/board/Source/post.lua:358: in function 'f'
./common.lua:17: in function <./common.lua:17>
[C]: in function 'xpcall'
./common.lua:16: in function 'handle_errors'
/srv/board/Source/post.lua:618: in main chunk
[C]: at 0x559941c2c2a0

P86558
>What kind of question is that?
the dreaming-about-nice-things one?
>spoiler 2
yea, that's right, in all likelihood she is a government assassin who will slice your throat the moment you rest your head and close your eyes,,,,,
stay alert, stay safe!

P86562
>the dreaming-about-nice-things one?
I meant that it's a question with an obvious answer.
>yea, that's right, in all likelihood she is a government assassin who will slice your throat the moment you rest your head and close your eyes,,,,,
>stay alert, stay safe!
Well, unfortunatelly the fear of being "found out" is always there.
>image
>naked knee high socks and randoseru
That's where boners are born.

P86563
>I meant that it's a question with an obvious answer.
nah i think there could be a fair amount of variety in the possible answers tbh
also the details the people could give would also vary
>Well, unfortunatelly the fear of being "found out" is always there.
did you do something like that? i mean, that one must be fairly innocent, there are real lg fuckers enjoying their life while also fearing that fear out there, but with that one you could get away without ever being suspected i guess
>That's where boners are born.
a man of culture, i see
what do you say about this one?

P86554
>>how I want to kiss a JI's sweet sexy legs.
>Don't we all?
Tfw no JI leg kissing brothel.

P86570
>did you do something like that?
Do what?
>but with that one you could get away without ever being suspected i guess
How tf am I supposed to explain the fact that I'm receiving hizamakura from a little girl if someone walks by?
>what do you say about this one?
What's the theme? Humiliation/exhibitionism plus maybe some pee stuff going on while we're at it? Not into those. Also udders.

P86554
shes a shitskin because she has that pathetic 6 year old male paki look, regardless of skin color

P86808 P86474
Now that is a preem girl. Just my shape. We could snuggle in my cot and have a good sleep.

P86808
This may suite your tastes.
[spoiler: I was going to upload it as a xz file for maximum irony, but I'm lazy to check if it has metadata].

suit*

only idoru posts quality threads these days

P86973
where yuki @

P86976
doing this

P86979
hikari so mad he's now posting screenshots of posts not by his crush jb lol
never got even roro to stay on his shitty clone lol

P86981

>jb

j-pan

P86981
you irate about something fag? wtf are you going on about

P86991
i'm not mad i'm amused lol
i see hikari so i remind him of the girls that all ignored him lol

P86981
isn't that a bit of a fib

she posted twice and then never again after realizing how dead and useless hikari's clone was lol
compare http://nanochanrayhy7nuuhldw2n4sq7tmv7xzdwaxtbptetss5eaznwfknyd.onion/b/123777 to P83219 lol

P86994
that is for P86993 lol

P86994

you need to stop assuming (or pretending to think, as it looks more like) other people are like you.

P86695
t.

P86994 the latter is full of word vomit... you're into that?

P86877
>metadata
why the fuck would a compression- actually nvm, why would it be backdoored too

P86976
i can not tell but he will be back
in a few months
sorry lambdaland

P86973
I rarely create threads though.

P87004
It's not exactly the same but zip files can have some metadata.

P86996
P86997
P86998
hikari so mad he replies to one post multiple times lol
not enough attention from girls so he has to beg for attention from us lol

P87047
You think so? Then never reply to a post you think is hikari then, faggot. Simple.

Only reply to or cite this post if you are a self-admitted worthless asswipe and wish to express agreement that anyone who replies (especially yourself, or any gay or bixseual man) deserves to be tortured to death.

hikari on his period again lol

Now having confirmed it, kill yourself, cut off your hands.

hikari muslim confirmed lol

P87048
who said i didn't like the result of giving you attention lol
you always produce more content for me when i do lol
i love seeing a schizocow flail and cry because he and his shitty clone are both seen as worthless by everyone, including the girls he simps for lol

P86644
>Do what?
smooching lg's thighs?
>How tf am I supposed to explain the fact that I'm receiving hizamakura from a little girl if someone walks by?
casual friendship?
also i haven't really set up the scenery so it could be entirely private sets and the only person you would have to convince that you are not being inappropriate would be her
>What's the theme? Humiliation/exhibitionism plus maybe some pee stuff going on while we're at it? Not into those.
lol
to me it looked more like mind games but yeah, with the humiliation theme
and it's not exhibitionism ffs, tho it could be used as a starter setting ig
>Also udders.
oh, that's the real issue. my bad
tho tbh oppai lolis could be underage as well and her build looks kinda childish imo, like she could be 10-12

P87067
hikari hates it when his worthless clone is called a clone when everyone recognizes it as one lol

P87068
hikari projecting his faggotry onto people here when he spends 80% of his time 18 hours refreshing here a day stalking and riding jb's dick lol
too bad jb only fucks the girl he likes most lol

P​87068
you know even with gigaaids ur life be an improvement and you be 1000% less disgusting to everyone
P​87097
no (((she))) calls (((herself))) (((attentionwhore)))
like you should but its even worse (((((((((attentionmanwhorevine))))))))) or amwvfaggot

here i found a quality and sane userbase for nanoray that will never leave
now i just have to import some thai ladybois er i mean females
this is a new golden age of tor imageboards i can just smell it from lightyears away

are you the troughposter and the "the rapist" poster?

P86979
first one of those posts is you know who

who is the troughposter?

P​87106
P​87107
P​87108
buddy im everyone on ljs1
aka >t. admin
now get off my site and never shill nano on it again
this is a clean tor community filled of the brightest mathematical minds not some transsexual femboy cult
i only allow single shillings and updates to /imageboards/

P​87111
admin

burp needs more crack

P87096
hikari thinks attaching a soyjak to a true statement will make his clone used by any of the nanochan userbase lol

P87097
P87100
hikari still devoting attention to the guy who gets more attention from the girls he likes than him lol

t. fellow anus object shover and equally alienated from reality

P87119
hikari still projecting his own faggotry onto others while he obsessed over one guy here lol
why does he love this site so much lol

correlation is not necessarily causation you know, just because shovers of objects up their anuses are also delusional doesn't mean object shoving causes the delusions

>correlation is not necessarily causation
damn what did god mean by making this hypercow npc

P87122
that could be partly true lol
i doubt you being a faggot causes the delusion that your clone is nanochan lol
or the delusion that lrh will ever give you attention lol
or the delusion that any girl here, lrh lacroix or roro will ever care for you lol
or the delusion that you'll ever dox and kill jb lol
or the delusion that everyone who doesn't like you (just everyone) is gay lol
or the delusion that you're here for "war" and not because this site is the only place where you can get any attention lol
there's more but i don't have all day lol

P86979
t. clueless, retarded, and also explicitly came out as gay

btw, hikari, how do you like to spend your free time? you never talk about yourself

P87136
spending hours and hours every day taking screenshots of posts and venting his anger on a site more relevant than his will ever be lol
what a way to live lol

babble babble babble lol
babble babble babble babble lol
babble babble babble lol
babble babble babble babble lol
babble babble babble lol
babble babble babble babble lol
babble babble babble lol
babble babble babble babble lol
babble babble babble lol
babble babble babble babble lol
babble babble babble lol
babble babble babble babble lol

sometimes i wonder if karl is an elaborate troll
sure its pathetic to put this much effort into trolling but its not as bad as simping this hard for real and getting nothing not even feet pics

durr durr my 4incher this
my 4incher that

my 4incher tho

hikari must be a troll fs, he has no other personality than being a lolcow, he doesnt seem to have any hobby or interest besides schizoing it up about

>>P87146

shut up faker

P87145
P87146
P87154
4inches

P​87153
this is the fallacy fellow autists fall for called assuming the other party is intelligent
tricked me enough times into assuming the other party is a fucking retard thats somehow more braindead than me

>>P87167

got a problem bigot?

now i do a lil meth and dxm tbg lol

P87171
no its cool to be a dicklet if femboy
ur a femboy right

false dichotomy

P87141
i wonder why hikari keeps replying to posts he claims to think are babble on a site he claims not to visit lol
nothing better to do when lrh doesn't give him any attention lol

P87155
schizophrenic hikari screenshotted something he could relate because he experiences it every waking hour of the day lol

P87205
fuck off. wtf is wrong with you? hikari dis an dat "lol"

P87208
hikari acts like there's something wrong with making fun of him when all he ever does here is talk about the guy who cucked him lol
irony lol
>fuck off
no lol

P87209
you already posted that one lol

P87212
the irony is the opposite is true

P87213
hikari still in denial about being cucked lol

you reckon

P87208
moo dis n lol dat lol

P87217
why do you love this site so much lol
you reply like average 10 times quicker than i do at this point lol
is it because you just need to see yourself getting cucked out of the girls you're following lol

P87218
the only one screaming here is you lol

hmm, sfs putting objects up there is from a log.

take the brown and pink pills

P87066
>smooching lg's thighs?
No.
>casual friendship?
>entirely private sets
Still scared. Also, I don't "believe" in having to keep relationship "secret".
>oppai lolis
GNO. Embrace flatness.

P87505
sweetie~
also sakurako posting lol

P87513
Yes, best yuru yuri and someone who needs to be softly whispered into her ear that she's perfectly fine the way she is.

P87517
oh i see
yea i remember her being jealous of the curves of her voluptous friend lol, they had a nice dynamic
me fav yryr is akarin tho
or maybe it is kyouko, i'm undecided

P87518
>akarin
>kyouko
I can respect those choices.

P87519
in the chinatsu-akarin relationship dynamic, are you chinatsu or are you akarin?
me akarin!

P87522
>chinktsu
I don't hate her but she might be one of my least liked ones.

P87524
well she is the bully of the club but at the same time i don't feel like she's evil tbh
but yea it's ok not to like her ig

P87525
I don't dislike her. Probably the only one I dislike is the one who drools, I forget her name.

P87526
>Probably the only one I dislike is the one who drools, I forget her name.
chitose or chizuru, one of the two twins lol
but why? is she too pervy for you or what?

P87527
Chizuru. Too much of a cock(?)blocker.

P87528
don't remember that lmao

P87530
She cockblocks Ayano and Kyouko because she wants Chitose and Ayano to be together.

P87815
ok
kyouko deserves to be the harem protagonist of that anime lol, so she would probably make ayano unhappy anyway

P87820
Well, yeah.
She's mostly good at being a baka.