select bands_songs.Title, bands_songs.Filename, bands.Path, bands_albums.Path from bands_songs, bands, bands_albums where bands_songs.ID = 10582 and bands_albums.ID = bands_songs.AlbumID and bands.ID = bands_albums.BandID