home / pf

albums_artists

6 rows where artist_id = 7511

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14505 14505 14149 14149 7511 7511
14944 14944 14593 14593 7511 7511
17153 17153 16855 16855 7511 7511
21251 21251 21127 21127 7511 7511
21601 21601 21487 21487 7511 7511
22998 22998 22902 22902 7511 7511

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