albums_artists

8 rows where artist_id = 2919

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3844 3844 3641 3641 2919 2919
4366 4366 4158 4158 2919 2919
6778 6778 6482 6482 2919 2919
7770 7770 7463 7463 2919 2919
8786 8786 8453 8453 2919 2919
9536 9536 9191 9191 2919 2919
10948 10948 10606 10606 2919 2919
11351 11351 11014 11014 2919 2919

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