albums_artists

7 rows where artist_id = 1915

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2219 2219 2080 2080 1915 1915
14475 14475 14119 14119 1915 1915
16876 16876 16566 16566 1915 1915
18771 18771 18529 18529 1915 1915
22548 22548 22454 22454 1915 1915
24313 24313 24201 24201 1915 1915
25977 25977 25878 25878 1915 1915

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