albums_artists

9 rows where artist_id = 255

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
262 262 251 251 255 255
3437 3437 3244 3244 255 255
6173 6173 5894 5894 255 255
13429 13429 13079 13079 255 255
13707 13707 13356 13356 255 255
16862 16862 16552 16552 255 255
18654 18654 18405 18405 255 255
20442 20442 20276 20276 255 255
22098 22098 22001 22001 255 255

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