albums_artists

5 rows where artist_id = 5653

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9796 9796 9449 9449 5653 5653
17024 17024 16721 16721 5653 5653
17025 17025 16722 16722 5653 5653
21799 21799 21693 21693 5653 5653
27459 27459 27284 27284 5653 5653

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