albums_artists

5 rows where artist_id = 2069

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2445 2445 2294 2294 2069 2069
4355 4355 4148 4148 2069 2069
4781 4781 4564 4564 2069 2069
6723 6723 6432 6432 2069 2069
24949 24949 24840 24840 2069 2069

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