albums_artists

7 rows where artist_id = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
75 75 73 73 70 70
1954 1954 1840 1840 70 70
3906 3906 3702 3702 70 70
5056 5056 4817 4817 70 70
6080 6080 5804 5804 70 70
6476 6476 6184 6184 70 70
6738 6738 6444 6444 70 70

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