Currently we are running a nested query to get blacklist from DB which can be slow and will not scale as the number of record increases.