home / pf

albums_artists

5 rows where artist_id = 5577

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9648 9648 9301 9301 5577 5577
13389 13389 13039 13039 5577 5577
16844 16844 16535 16535 5577 5577
19184 19184 18963 18963 5577 5577
21823 21823 21720 21720 5577 5577

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