albums_artists

5 rows where artist_id = 2526

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3160 3160 2982 2982 2526 2526
5217 5217 4972 4972 2526 2526
7213 7213 6914 6914 2526 2526
8910 8910 8574 8574 2526 2526
23112 23112 23011 23011 2526 2526

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