albums_artists

8 rows where artist_id = 342

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
349 349 333 333 342 342
1181 1181 1112 1112 342 342
1804 1804 1704 1704 342 342
2686 2686 2525 2525 342 342
4411 4411 4198 4198 342 342
5887 5887 5620 5620 342 342
6162 6162 5883 5883 342 342
26595 26595 26481 26481 342 342

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