home / pf

albums_artists

7 rows where artist_id = 2159

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2592 2592 2440 2440 2159 2159
15809 15809 15467 15467 2159 2159
16981 16981 16673 16673 2159 2159
21982 21982 21882 21882 2159 2159
23241 23241 23138 23138 2159 2159
24935 24935 24826 24826 2159 2159
25816 25816 25717 25717 2159 2159

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