home / pf

albums_artists

8 rows where artist_id = 7304

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13959 13959 13602 13602 7304 7304
15487 15487 15144 15144 7304 7304
17567 17567 17271 17271 7304 7304
22006 22006 21906 21906 7304 7304
24373 24373 24260 24260 7304 7304
24976 24976 24868 24868 7304 7304
25790 25790 25691 25691 7304 7304
26160 26160 26058 26058 7304 7304

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.294ms