albums_artists

7 rows where artist_id = 3492

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4887 4887 4660 4660 3492 3492
5793 5793 5526 5526 3492 3492
6065 6065 5790 5790 3492 3492
7388 7388 7088 7088 3492 3492
7978 7978 7664 7664 3492 3492
8810 8810 8477 8477 3492 3492
10495 10495 10156 10156 3492 3492

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