albums_artists

7 rows where artist_id = 125

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
130 130 126 126 125 125
394 394 375 375 125 125
3050 3050 2875 2875 125 125
8780 8780 8449 8449 125 125
10605 10605 10268 10268 125 125
22314 22314 22224 22224 125 125
24354 24354 24240 24240 125 125

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