albums_artists

7 rows where artist_id = 254

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
260 260 249 249 254 254
261 261 250 250 254 254
1525 1525 1439 1439 254 254
3018 3018 2844 2844 254 254
7881 7881 7563 7563 254 254
11714 11714 11372 11372 254 254
13403 13403 13053 13053 254 254

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