albums_artists

11 rows where artist_id = 525

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
540 540 517 517 525 525
589 589 565 565 525 525
1141 1141 1076 1076 525 525
1396 1396 1314 1314 525 525
1421 1421 1337 1337 525 525
1470 1470 1386 1386 525 525
1572 1572 1483 1483 525 525
1578 1578 1489 1489 525 525
1602 1602 1513 1513 525 525
1650 1650 1556 1556 525 525
1783 1783 1683 1683 525 525

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