home / pf

albums_artists

6 rows where artist_id = 7603

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14758 14758 14404 14404 7603 7603
18772 18772 18530 18530 7603 7603
20830 20830 20678 20678 7603 7603
22862 22862 22767 22767 7603 7603
23959 23959 23845 23845 7603 7603
25826 25826 25727 25727 7603 7603

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