home / pf

albums_artists

5 rows where artist_id = 7302

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13955 13955 13598 13598 7302 7302
15795 15795 15456 15456 7302 7302
17629 17629 17334 17334 7302 7302
18405 18405 18135 18135 7302 7302
19011 19011 18780 18780 7302 7302

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