albums_artists

10 rows where artist_id = 287

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
294 294 281 281 287 287
2909 2909 2740 2740 287 287
5621 5621 5360 5360 287 287
8964 8964 8624 8624 287 287
9642 9642 9295 9295 287 287
16384 16384 16071 16071 287 287
20586 20586 20425 20425 287 287
25656 25656 25558 25558 287 287
26088 26088 25984 25984 287 287
26393 26393 26287 26287 287 287

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