albums_artists

8 rows where artist_id = 2202

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2653 2653 2494 2494 2202 2202
3550 3550 3353 3353 2202 2202
4322 4322 4118 4118 2202 2202
5291 5291 5043 5043 2202 2202
5359 5359 5107 5107 2202 2202
5802 5802 5534 5534 2202 2202
26441 26441 26334 26334 2202 2202
27442 27442 27268 27268 2202 2202

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