I would like to search in my database all title that are redundants (!= files), i.e. each file which refer to a combination {artist+title} also used by another file.
For example, if I have the following combination:
file1 ArtistA TitleA
file2 ArtistA TitleA
file3 ArtistA TitleB
file4 ArtistA TitleC
file5 ArtistA TitleD
file6 ArtistA TitleD
file7 ArtistA TitleE
file8 ArtistA TitleD
file9 ArtistB TitleG
file10 ArtistC TitleC
file11 ArtistC TitleE
file12 ArtistC TitleE
file13 ArtistD TitleH
file14 ArtistE TitleI
I would like that the query returns
file1 ArtistA TitleA
file2 ArtistA TitleA
file5 ArtistA TitleD
file6 ArtistA TitleD
file8 ArtistA TitleD
file11 ArtistC TitleE
file12 ArtistC TitleE
The goal for me would be to remove these duplicates files.
Is there a plug in which could make such a query? How?
Maybe you could write a lua script (with foo_lua) that would do that.
Search the other threads if you need more info on foo_lua.