home / pf

albums_artists

6 rows where artist_id = 4639

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7386 7386 7087 7087 4639 4639
9402 9402 9054 9054 4639 4639
11678 11678 11340 11340 4639 4639
18161 18161 17877 17877 4639 4639
22119 22119 22022 22022 4639 4639
23363 23363 23259 23259 4639 4639

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.424ms