SELECT 'ipaddress', 'username' FROM tables
WHERE (username.normalize() == "jomiran"
OR post.links CONTAIN "jomiran")
FILTER content IN _blacklist_keywords;
Or some such. Data is easy to mine if you have a target. It's finding unknown targets that is hard.