albums_artists

5 rows where artist_id = 2593

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3266 3266 3083 3083 2593 2593
5262 5262 5018 5018 2593 2593
6304 6304 6018 6018 2593 2593
7366 7366 7067 7067 2593 2593
8971 8971 8631 8631 2593 2593

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