Tabel relations

[HCICT]

Hi All,

I like to make a overview of topics/posts made in specific forums and date. Now there isn't a option in statistics in the admin cp, so I like to do it with query's.

What I made:

select count(*)
From 'forums_topics'
Where forum_id IN (428,429,430,431,432,433) AND
from_unixtime(start_date) > STR_TO_DATE('06/08/2017', '%m/%d/%Y')

But this only show the topics that are made. I like also to know how many posts are maiden.
Now I was checking core_message_topics but I couldn't really find any relation with this forums or topics..

Do someone know how I can achieve this?

[Faqole]

You must query the forums_posts table to get the posts.