albums_artists

5 rows where artist_id = 5365

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9206 9206 8863 8863 5365 5365
11481 11481 11144 11144 5365 5365
15111 15111 14766 14766 5365 5365
17227 17227 16924 16924 5365 5365
22502 22502 22406 22406 5365 5365

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