albums_artists

7 rows where artist_id = 1254

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1363 1363 1283 1283 1254 1254
4155 4155 3954 3954 1254 1254
6192 6192 5912 5912 1254 1254
6912 6912 6613 6613 1254 1254
8490 8490 8159 8159 1254 1254
10046 10046 9701 9701 1254 1254
27392 27392 27219 27219 1254 1254

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