albums_artists

5 rows where artist_id = 2444

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3046 3046 2871 2871 2444 2444
3839 3839 3638 3638 2444 2444
5494 5494 5238 5238 2444 2444
6377 6377 6088 6088 2444 2444
27303 27303 27136 27136 2444 2444

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