home / pf

albums_artists

5 rows where artist_id = 6058

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10741 10741 10407 10407 6058 6058
12445 12445 12105 12105 6058 6058
14936 14936 14588 14588 6058 6058
19189 19189 18968 18968 6058 6058
21387 21387 21265 21265 6058 6058

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 66.156ms