albums_artists

5 rows where artist_id = 797

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
830 830 784 784 797 797
3494 3494 3298 3298 797 797
4434 4434 4220 4220 797 797
25953 25953 25854 25854 797 797
26193 26193 26091 26091 797 797

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