albums_artists

6 rows where artist_id = 2138

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2552 2552 2400 2400 2138 2138
4864 4864 4638 4638 2138 2138
6770 6770 6476 6476 2138 2138
14513 14513 14157 14157 2138 2138
18011 18011 17721 17721 2138 2138
18356 18356 18081 18081 2138 2138

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