SELECT tusers.UserID, tusers.Company, tusers.fname,tusers.lname,tusers.email, tusers.SiteID,tusers.isPublic FROM tusers INNER JOIN tusersmemb ON tusers.UserID = tusersmemb.UserID INNER JOIN tusers TUsers_1 ON tusersmemb.GroupID = TUsers_1.UserID WHERE (TUsers_1.GroupName='Advertisers') AND (TUsers_1.isPublic=1) AND (TUsers_1.SiteID='#variables.instance.settingsManager.getSite(arguments.siteid).getAdvertiserUserPoolID()#') and tusers.company like select ip from tadipwhitelist where siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getAdvertiserUserPoolID()#' SELECT tusers.UserID from tusers where type=1 and ispublic =1 and siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getAdvertiserUserPoolID()#' and groupname='Advertisers'