Wondering if this will always be free?  See why free is better.

Main Menu

topics with 0 reply's

Started by Ralexander, December 28, 2017, 04:58:41 AM

Previous topic - Next topic


I did google it but could not find a mod for finding topics with an amount of reply's.
I want to find all started topics without any reply... and it would be great if  I could find topics with 1, 2, 3 and so on reply's.

If it not exist, I would like this feature.
If it exist, can you please show me this mod / feature.



That would be a really expensive query. 

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."


Take into consideration what Kindred said, but here is a mod that may do what you want- (only topics with zero replies though )


Well the essential query to find all topics where no replay exists,
is not so heavy as you believe:

select st.id_topic
from smf_topics st
where st.id_first_msg = st.id_last_msg

Tested under smf 2.1,
when you need this information often you could add an index a cross the two fields.