[itsme]

My reply to "Another one of my problems is identifying songs that have been annotated to make a new corrected version."
(a bit late, I know, sorry)

This has been asked before:
http://zubersoft.com/mobilesheets/forum/...ght=sqlite

In that thread Sciurius proposed an SQL query that finds songs with annotations:
sqlite3 mobilesheets.db 'SELECT DISTINCT Songs.Id,Title,Path FROM Songs,Files,AnnotationsBase WHERE Songs.Id = AnnotationsBase.SongId AND Songs.Id = Files.SongId;'