albums_artists

6 rows where artist_id = 6204

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11055 11055 10715 10715 6204 6204
15494 15494 15151 15151 6204 6204
17256 17256 16953 16953 6204 6204
19345 19345 19128 19128 6204 6204
21538 21538 21418 21418 6204 6204
22108 22108 22011 22011 6204 6204

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