albums_artists

5 rows where artist_id = 1334

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1457 1457 1373 1373 1334 1334
3602 3602 3407 3407 1334 1334
6204 6204 5924 5924 1334 1334
10351 10351 10009 10009 1334 1334
27269 27269 27104 27104 1334 1334

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