albums_artists

8 rows where artist_id = 7789

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15356 15356 15014 15014 7789 7789
18135 18135 17851 17851 7789 7789
18869 18869 18626 18626 7789 7789
20192 20192 20015 20015 7789 7789
22974 22974 22877 22877 7789 7789
25497 25497 25396 25396 7789 7789
25983 25983 25884 25884 7789 7789
26184 26184 26082 26082 7789 7789

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