albums_artists

8 rows where artist_id = 326

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
333 333 318 318 326 326
1837 1837 1735 1735 326 326
4219 4219 4017 4017 326 326
6691 6691 6400 6400 326 326
7931 7931 7618 7618 326 326
17608 17608 17313 17313 326 326
19125 19125 18901 18901 326 326
20144 20144 19967 19967 326 326

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