(01 Jan 2024, 20:11 )Like Ra Wrote: [ -> ]Most active threads in 2023:
Interestingly enough, 13 out 20 top threads are hypno related.
(01 Jan 2024, 19:14 )Like Ra Wrote: [ -> ]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.
Can you make comparison by top thred/year ?
Maybe it would be interesting to see how we change during the years
(01 Jan 2024, 22:01 )Vixien Wrote: [ -> ]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?
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.
(02 Jan 2024, 00:21 )Vixien Wrote: [ -> ]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.
(01 Jan 2024, 21:24 )Like Ra Wrote: [ -> ]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!
(02 Jan 2024, 09:18 )ltxrob Wrote: [ -> ]Hypno is the topic of least interest for me!
That's why we have hundreds of others! 😉
Oh, another stat! Time spent online in hours:
Offtopic: BTW, I used ChatGPT to format the results in MyBB tables. Brilliant!
Since I'm learning SQL, here's another stat for you: amount of attachments and the total attachment size per user:
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...