I think I've fount what I was looking for. There is and index, idxSongsSignature that works on Songs.SignPart1.

Thank you!

Oh! Ok, thanks.
How about the Duplicate by Content? Is there a way I can search that?

Thanks!!

There is no table for that, you'd need to do some query yourself that matches fields (ie. like same Artist and same Title) to determine if files are duplicates.

You may want to check if you're not duplicating features already in the Advanced Duplicate Find & Fix Addon: http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=13000&hilit=advanced+duplicate

Guys,

I'm working in developing a script (soon to be an extension) to smartly delete dups.
How can I query the database to retrieve a list of all the dup files?

Thanks!