deleting multiple non working songs

If you know which ones are not available (marked with an icon), you could sort the collection by that column. Duplicates are more difficult to remove and should be done manually or with a 3rd party application for managing duplicates within your music collection.