I have an advertiser that wants to know how many threads / topics there are in each forum "Category" and "Section".
Sure, I could just go through and count on my homepage, but I like learning new things and thought running a SQL query via phpMyAdmin that would bring up the data would be better... especially since I could also put time boundaries on the data, for example:
- Topics Per Category - Past 180 days
- Topics Per Forum - Past 500 days
... problem is that I'm FAR from a SQL expert... which is why I come to you!
So, is anyone willing to write the basic SQL query for the first or both of the queries above?
Thanks in advance for your help!