albums_artists

10 rows where artist_id = 2623

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3323 3323 3138 3138 2623 2623
4829 4829 4609 4609 2623 2623
5837 5837 5570 5570 2623 2623
7550 7550 7244 7244 2623 2623
11018 11018 10676 10676 2623 2623
11442 11442 11104 11104 2623 2623
12222 12222 11886 11886 2623 2623
13503 13503 13152 13152 2623 2623
14246 14246 13886 13886 2623 2623
26494 26494 26384 26384 2623 2623

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