albums_artists

13 rows where artist_id = 6416

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11568 11568 11230 11230 6416 6416
12390 12390 12054 12054 6416 6416
16399 16399 16085 16085 6416 6416
19980 19980 19794 19794 6416 6416
23314 23314 23210 23210 6416 6416
23976 23976 23863 23863 6416 6416
24180 24180 24070 24070 6416 6416
25090 25090 24987 24987 6416 6416
25115 25115 25011 25011 6416 6416
25751 25751 25651 25651 6416 6416
26130 26130 26027 26027 6416 6416
26396 26396 26290 26290 6416 6416
26849 26849 26710 26710 6416 6416

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