albums_artists

12 rows where artist_id = 1367

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1495 1495 1411 1411 1367 1367
6708 6708 6417 6417 1367 1367
7840 7840 7526 7526 1367 1367
13885 13885 13528 13528 1367 1367
17986 17986 17695 17695 1367 1367
19235 19235 19015 19015 1367 1367
20083 20083 19902 19902 1367 1367
25767 25767 25668 25668 1367 1367
25768 25768 25669 25669 1367 1367
25957 25957 25858 25858 1367 1367
25958 25958 25859 25859 1367 1367
25984 25984 25885 25885 1367 1367

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