albums_artists

10 rows where artist_id = 6518

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11785 11785 11445 11445 6518 6518
13106 13106 12768 12768 6518 6518
13548 13548 13196 13196 6518 6518
20705 20705 20544 20544 6518 6518
21635 21635 21522 21522 6518 6518
21873 21873 21769 21769 6518 6518
22426 22426 22331 22331 6518 6518
22981 22981 22884 22884 6518 6518
24216 24216 24105 24105 6518 6518
24587 24587 24465 24465 6518 6518

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