albums_artists

6 rows where artist_id = 649

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
671 671 644 644 649 649
2626 2626 2472 2472 649 649
4305 4305 4101 4101 649 649
7092 7092 6793 6793 649 649
9166 9166 8823 8823 649 649
13653 13653 13302 13302 649 649

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);