im_spam_multi_group_exists_clause

im_spam_multi_group_exists_clause   group_id_list

returns a portion of an sql where clause that begins with " and exists..." and includes all the groups in the comma separated list of group ids (group_id_list)

Source code:

    set criteria [list]
    foreach group_id [split $group_id_list ","] {
	lappend criteria "(select 1 from user_group_map ugm where u.user_id=ugm.user_id and ugm.group_id='$group_id')"
    }
    if { [llength $criteria] > 0 } {
	return " and exists [join $criteria " and exists "] "
    } else {
	return ""
    }