This query should work now and should be equivalent to the same you had before. Please be aware that this query will return one row per violation (contain the columns that are actually redundant) only. If this is to be presented to a user, it might be a good idea to join the rest of the data as well. I have been playing around with that a bit locally.