albums_artists

6 rows where artist_id = 2583

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3251 3251 3068 3068 2583 2583
5888 5888 5621 5621 2583 2583
9087 9087 8747 8747 2583 2583
12663 12663 12323 12323 2583 2583
13801 13801 13446 13446 2583 2583
26553 26553 26441 26441 2583 2583

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