Non Spam Posts for a given time frame
I'm trying to retrieve the number of non-spam posts within a specific timeframe from my database. What should the query be in this case?
Forum Discussion
CarlaAYou can fetch the messages that are not marked as SPAM by including the following condition in your query: moderation_status: "approved".
For ex: select count(*) from messages where moderation_status="approved" and post_time>=2025-01-01T00:00:00.000-00:00 and post_time <= 2025-02-26T23:59:59.999-00:00
