albums_artists

6 rows where artist_id = 2954

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3904 3904 3700 3700 2954 2954
6670 6670 6379 6379 2954 2954
7333 7333 7036 7036 2954 2954
8524 8524 8192 8192 2954 2954
9627 9627 9279 9279 2954 2954
27580 27580 27391 27391 2954 2954

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