home / pf

albums_artists

9 rows where artist_id = 9200

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
19176 19176 18954 18954 9200 9200
20298 20298 20127 20127 9200 9200
21614 21614 21500 21500 9200 9200
22074 22074 21978 21978 9200 9200
22318 22318 22229 22229 9200 9200
23042 23042 22946 22946 9200 9200
24011 24011 23900 23900 9200 9200
24134 24134 24024 24024 9200 9200
25046 25046 24939 24939 9200 9200

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)
);
Powered by Datasette · Queries took 60.965ms