Print Page | Close Window

MySql Statistical filter match query

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4565
Printed Date: 27 December 2024 at 1:15pm


Topic: MySql Statistical filter match query
Posted By: keizersozay
Subject: MySql Statistical filter match query
Date Posted: 15 November 2004 at 12:13pm

Is there an easy way to see which messages are blocked by the Bayes filter? Using the quarantine viewer in spamfilter is tedious and I can’t seem to find anything with a reject id of 14, which I believe is the id for the bayes filter... (when I run the other MySql query posted by Roberto it says that I do have some messages rejected by the statistical filter match.)

 

Anyone know of a mysql query?


Replies:
Posted By: keizersozay
Date Posted: 15 November 2004 at 1:55pm

SELECT     tblMsgs.MsgId, tblMsgs.Msg
FROM         tblQuarantine INNER JOIN
                      tblMsgs ON tblQuarantine.MsgID = tblMsgs.MsgID and tblQuarantine.RejectID = 14
GROUP BY tblMsgs.MsgID;

 

This seems to be working for me.
I use the mysql control center to run the queries so that they are easier to read.


Print Page | Close Window