home / pf

albums_artists

5 rows where artist_id = 7188

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13535 13535 13184 13184 7188 7188
17225 17225 16922 16922 7188 7188
19908 19908 19721 19721 7188 7188
23015 23015 22919 22919 7188 7188
24674 24674 24551 24551 7188 7188

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