albums_artists

6 rows where artist_id = 2567

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3222 3222 3039 3039 2567 2567
11938 11938 11595 11595 2567 2567
15673 15673 15335 15335 2567 2567
19370 19370 19154 19154 2567 2567
21269 21269 21145 21145 2567 2567
23113 23113 23012 23012 2567 2567

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