albums_artists

5 rows where artist_id = 1273

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1383 1383 1302 1302 1273 1273
3216 3216 3033 3033 1273 1273
5995 5995 5724 5724 1273 1273
7845 7845 7531 7531 1273 1273
8654 8654 8319 8319 1273 1273

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