Site statistics

[Like Ra]

Most active threads in 2023:

Interestingly enough, 13 out 20 top threads are hypno related.

January 01! The Statistics Day!

3 most viewed threads (2.7million combined views) are hypno related.

Since hypno-users "overflow" to other threads, adding the hypnosis section is a success to the whole site.

[Vixien]

Can you make comparison by top thred/year ?
Maybe it would be interesting to see how we change during the years

[Like Ra]

Can you make comparison by top thread/year ?

Not sure if I understand what you mean? By the amount of comments per year? Have a look here: https://www.likera.com/forum/mybb/activethreads.php - at the bottom you can choose the date until which to count replies (e.g. 2021-01-01), and the amount of days to count (e.g. 365)

Or do you mean something different?

[Vixien]

You wrote that most active threads in 2023 are hypno related .

It would be interested to see what were the most active threads in past years.

[Like Ra]

It would be interested to see what were the most active threads in past years.

Then my quick tutorial will work 😊 - you can choose any period of time, beginning 2006 and check by yourself.

The thing is, the pure amount of posts per year has grown significantly, so, post-amount-wise, it's difficult to compare.

[ltxrob]

Interestingly enough, 13 out 20 top threads are hypno related.

and Hypno is the topic of least interest for me!
But i do occasionally glance at the odd thread here and there...

but if its great for the site... then thats a bonus!

[Like Ra]

Hypno is the topic of least interest for me!

That's why we have hundreds of others! 😉

[Like Ra]

Oh, another stat! Time spent online in hours:

Order	Username	TimeOnline
1	@Like Ra	44396.5547
2	@nacd1234	10782.2789
3	@NoNeedToBreathe	2171.7597
4	@jasapasa	1586.5303
5	@madjack	1473.1856
6	@Atsta	1410.9553
7	@Culmor	1240.0569
8	@Ruis	1232.5850
9	@krinlyc	1211.2539
10	@essanym	1114.9575
11	@Chel	1082.4289
12	@trismegist	1067.2231
13	@Penguin	1036.9906
14	@DeWired	838.2264
15	@Tinker D	832.3650
16	@Zooy	818.3619
17	@ephemeral	809.3753
18	@Jiraiya	796.4642
19	@jtr765	712.7722
20	@Vacbedbound	702.3811

[Like Ra]

Offtopic: BTW, I used ChatGPT to format the results in MyBB tables. Brilliant!

[Like Ra]

Since I'm learning SQL, here's another stat for you: amount of attachments and the total attachment size per user:

Order	Username	Attachments	Total size (MB)
1	@Like Ra	23789	26125.2675
2	@madjack	10176	3782.9977
3	@helpless85	2222	2686.8327
4	@Culmor	1748	960.6063
5	@madboyevil	1288	414.2951
6	@TightSlip	1169	518.1381
7	@PurpleVibes	1022	89.2773
8	@jessilongstocking	672	140.3578
9	@Bound Whore	579	900.8296
10	@Vacbedbound	441	874.3204
11	@mysecretpantyhose	413	201.5382
12	@q1911	319	151.3579
13	@Anne	280	355.8364
14	@FagMan	259	118.8914
15	@Strappado	248	36.8794
16	@latexballet	228	58.3596
17	@essanym	199	250.1289
18	@ltxrob	187	132.3637
19	@Tinker D	148	119.7455
20	@latexpert	148	29.7706

Code:

WITH t AS (
SELECT mybb_users.username, COUNT(mybb_attachments.uid) AS cnt, SUM(mybb_attachments.filesize)/1048576 AS sum
FROM mybb_attachments
JOIN mybb_users
ON mybb_users.uid = mybb_attachments.uid
GROUP BY mybb_attachments.uid
ORDER BY cnt DESC
LIMIT 20)
SELECT ROW_NUMBER() OVER (), t.username, t.cnt, t.sum
FROM t

If anybody speaks SQL, can this be done more efficiently? I'm just trying various things...