albums_artists

7 rows where artist_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
40 40 40 40 35 35
2473 2473 2322 2322 35 35
5018 5018 4779 4779 35 35
6343 6343 6055 6055 35 35
6345 6345 6056 6056 35 35
6346 6346 6057 6057 35 35
6348 6348 6058 6058 35 35

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