albums_artists

7 rows where artist_id = 672

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
695 695 663 663 672 672
696 696 664 664 672 672
3668 3668 3472 3472 672 672
5735 5735 5471 5471 672 672
7562 7562 7257 7257 672 672
9104 9104 8764 8764 672 672
27490 27490 27313 27313 672 672

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