albums_artists

6 rows where artist_id = 2780

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3592 3592 3397 3397 2780 2780
3593 3593 3398 3398 2780 2780
3594 3594 3399 3399 2780 2780
3595 3595 3400 3400 2780 2780
3596 3596 3401 3401 2780 2780
26145 26145 26042 26042 2780 2780

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