albums_artists

5 rows where artist_id = 5433

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9332 9332 8985 8985 5433 5433
11413 11413 11074 11074 5433 5433
12366 12366 12030 12030 5433 5433
14908 14908 14562 14562 5433 5433
16535 16535 16221 16221 5433 5433

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