albums_artists

7 rows where artist_id = 2506

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3134 3134 2956 2956 2506 2506
8176 8176 7858 7858 2506 2506
12167 12167 11829 11829 2506 2506
14672 14672 14316 14316 2506 2506
20950 20950 20804 20804 2506 2506
23487 23487 23381 23381 2506 2506
25542 25542 25443 25443 2506 2506

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