$sql_select_policy =
|
'SELECT *,spamfilter_users.id'.
|
' FROM spamfilter_users LEFT JOIN spamfilter_policy ON spamfilter_users.policy_id=spamfilter_policy.id'.
|
' WHERE spamfilter_users.email IN (%k) ORDER BY spamfilter_users.priority DESC';
|
|
|
$sql_select_white_black_list = 'SELECT wb FROM spamfilter_wblist'.
|
' WHERE (spamfilter_wblist.rid=?) AND (spamfilter_wblist.email IN (%k))' .
|
' ORDER BY spamfilter_wblist.priority DESC';
|