Anyone have a query that could prune the IP table selectively?
Specifically - keep only IPs for those in Banned Usergroup (usergroup x) AND keep ALL IPs for the last 1 year. Truncate the rest.
Our table is very very large, going back 17 years, but it's not needed for the most part. What is...