albums_artists

23 rows where artist_id = 5340

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9130 9130 8787 8787 5340 5340
9131 9131 8788 8788 5340 5340
9132 9132 8789 8789 5340 5340
9133 9133 8790 8790 5340 5340
9134 9134 8791 8791 5340 5340
9135 9135 8792 8792 5340 5340
9136 9136 8793 8793 5340 5340
9137 9137 8794 8794 5340 5340
9138 9138 8795 8795 5340 5340
9139 9139 8796 8796 5340 5340
9140 9140 8797 8797 5340 5340
9141 9141 8798 8798 5340 5340
9142 9142 8799 8799 5340 5340
9143 9143 8800 8800 5340 5340
9144 9144 8801 8801 5340 5340
9145 9145 8802 8802 5340 5340
9146 9146 8803 8803 5340 5340
9147 9147 8804 8804 5340 5340
9148 9148 8805 8805 5340 5340
9149 9149 8806 8806 5340 5340
9150 9150 8807 8807 5340 5340
9151 9151 8808 8808 5340 5340
9152 9152 8809 8809 5340 5340

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