home / pf

albums_artists

6 rows where artist_id = 7583

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14714 14714 14360 14360 7583 7583
17523 17523 17228 17228 7583 7583
19248 19248 19029 19029 7583 7583
20575 20575 20414 20414 7583 7583
23124 23124 23023 23023 7583 7583
23372 23372 23269 23269 7583 7583

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