home / pf

albums_artists

5 rows where artist_id = 6365

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11422 11422 11083 11083 6365 6365
19775 19775 19579 19579 6365 6365
22936 22936 22839 22839 6365 6365
24127 24127 24017 24017 6365 6365
24675 24675 24552 24552 6365 6365

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