albums_artists

5 rows where artist_id = 1396

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1530 1530 1444 1444 1396 1396
2450 2450 2299 2299 1396 1396
3771 3771 3571 3571 1396 1396
8379 8379 8055 8055 1396 1396
10731 10731 10397 10397 1396 1396

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