albums_artists

6 rows where artist_id = 6876

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12687 12687 12347 12347 6876 6876
17911 17911 17618 17618 6876 6876
18937 18937 18701 18701 6876 6876
22398 22398 22304 22304 6876 6876
23887 23887 23775 23775 6876 6876
25890 25890 25792 25792 6876 6876

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)
);