$query = "
select COUNT(USER_ID)
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID = ?
and USER_ID IN
(select distinct USER_ID
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID <> ?)
";
$sth = $dbh->do_placeholder_query($query,array($k,$k),__LINE__,__FILE__);
list($in_other) = $dbh->fetch_array($sth);