albums_artists

5 rows where artist_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
303 303 290 290 296 296
3013 3013 2840 2840 296 296
4433 4433 4219 4219 296 296
5517 5517 5261 5261 296 296
6600 6600 6311 6311 296 296

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