I want to search the entire database for duplicate individual records.
Although there is a "Duplicate records" function in the control panel, it is done by querying the wt_date table and it is not possible to find all duplicate records.
I want to SQL both the father's name and the son's name (it would be nice to include the grandfather's name as well) and their xrefs, which is most likely a duplicate record when there are two identical records (both with the same father and son's name).
How do I write this Sql statement? Thank you.