albums_artists

6 rows where artist_id = 611

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
631 631 607 607 611 611
3375 3375 3184 3184 611 611
5905 5905 5637 5637 611 611
8545 8545 8212 8212 611 611
11336 11336 10999 10999 611 611
13443 13443 13090 13090 611 611

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