albums_artists

8 rows where artist_id = 294

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
301 301 288 288 294 294
2928 2928 2758 2758 294 294
5967 5967 5697 5697 294 294
11637 11637 11300 11300 294 294
15222 15222 14877 14877 294 294
16382 16382 16069 16069 294 294
18125 18125 17840 17840 294 294
19186 19186 18965 18965 294 294

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