XF 2.2 Search for most replied threads for a year?

[ArtG]

Hi all,

As we come close to the end of the year, I would like to make a Top Threads post showing the most active threads of 2023.

Does anyone know of a way to find the most replied to threads for a specific period of time (2023)?

Thanks in advance,

Art

 

[jeb35]

Without the use of an addon, the only thing you can do is access each forum and use the filter option to sort by replies and then descending. That will show you the threads with the most replies in that forum.

 

[Kirby]

Does anyone know of a way to find the most replied to threads for a specific period of time (2023)?

Top 100 visible replied to threads started in 2023

SELECT thread_id, title, reply_count FROM xf_thread WHERE YEAR(FROM_UNIXTIME(post_date)) = 2023 AND discussion_state ='visible' AND discussion_type != 'redirect' ORDER BY reply_count DESC LIMIT 100