albums_artists

5 rows where artist_id = 5525

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9518 9518 9173 9173 5525 5525
13426 13426 13076 13076 5525 5525
14958 14958 14608 14608 5525 5525
15877 15877 15533 15533 5525 5525
26822 26822 26686 26686 5525 5525

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