Separator =”or”; separator=”,”; and is not in the inner loop.

and ( login_name in (“”,””,…)  or  login_name in (“”,””,…) ),

LoginNameList can segment a large list of a specified size using guava’s method of segmenting the list

newList = Lists.partten(list,size);