albums_artists

8 rows where artist_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17 17 17 17 12 12
1485 1485 1401 1401 12 12
3020 3020 2846 2846 12 12
4510 4510 4293 4293 12 12
7376 7376 7077 7077 12 12
8718 8718 8385 8385 12 12
9062 9062 8722 8722 12 12
27538 27538 27352 27352 12 12

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