albums_artists

6 rows where artist_id = 1323

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1443 1443 1359 1359 1323 1323
5658 5658 5395 5395 1323 1323
8154 8154 7835 7835 1323 1323
10590 10590 10252 10252 1323 1323
12463 12463 12125 12125 1323 1323
17412 17412 17118 17118 1323 1323

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