albums_artists

5 rows where artist_id = 1224

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1330 1330 1251 1251 1224 1224
17540 17540 17246 17246 1224 1224
19197 19197 18976 18976 1224 1224
19838 19838 19644 19644 1224 1224
22478 22478 22382 22382 1224 1224

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