albums_artists

5 rows where artist_id = 2455

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3061 3061 2886 2886 2455 2455
4091 4091 3892 3892 2455 2455
5900 5900 5632 5632 2455 2455
8249 8249 7929 7929 2455 2455
8945 8945 8608 8608 2455 2455

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