albums_artists

6 rows where artist_id = 1341

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1464 1464 1380 1380 1341 1341
3322 3322 3137 3137 1341 1341
6333 6333 6046 6046 1341 1341
11601 11601 11263 11263 1341 1341
13849 13849 13492 13492 1341 1341
26876 26876 26735 26735 1341 1341

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