sql query to show all not active forums?

[admolot]

Hi,

I would like to know which mySQL query I have to run to see all forums which have 0 posts for 1 month...

Any help would be appreciated.

[Eikinskjaldi]

forums have a lastpost field which stores the dateline of the last post.

You thus need to grab the lastpost and check it against some measure of "month"

one possibility:

select forumid from forum where to_days(now()) - to_days(from_unixtime(lastpost)) > 30

[admolot]

thanks, it works...

is there any way I can exclude some of the forums from search?

[Michael Biddle]

where forumid != x

[Kirk Y]

It'd be AND in this particular case, as there's already a WHERE statement.