albums_artists

8 rows where artist_id = 2474

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3083 3083 2906 2906 2474 2474
4707 4707 4490 4490 2474 2474
5997 5997 5726 5726 2474 2474
7391 7391 7091 7091 2474 2474
9667 9667 9321 9321 2474 2474
10541 10541 10202 10202 2474 2474
11939 11939 11596 11596 2474 2474
15460 15460 15121 15121 2474 2474

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