home / pf

albums_artists

5 rows where artist_id = 7462

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14361 14361 14002 14002 7462 7462
19185 19185 18964 18964 7462 7462
23546 23546 23442 23442 7462 7462
25706 25706 25606 25606 7462 7462
26377 26377 26271 26271 7462 7462

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