home / pf

albums_artists

6 rows where artist_id = 4994

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8286 8286 7967 7967 4994 4994
18565 18565 18309 18309 4994 4994
21908 21908 21804 21804 4994 4994
22896 22896 22802 22802 4994 4994
24002 24002 23891 23891 4994 4994
25235 25235 25130 25130 4994 4994

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