albums_artists

7 rows where artist_id = 194

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
199 199 192 192 194 194
2984 2984 2812 2812 194 194
4796 4796 4578 4578 194 194
6044 6044 5770 5770 194 194
8588 8588 8254 8254 194 194
11552 11552 11214 11214 194 194
12921 12921 12579 12579 194 194

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