home / pf

albums_artists

8 rows where artist_id = 7032

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13159 13159 12820 12820 7032 7032
16722 16722 16413 16413 7032 7032
18165 18165 17881 17881 7032 7032
20636 20636 20473 20473 7032 7032
23714 23714 23605 23605 7032 7032
23916 23916 23801 23801 7032 7032
24742 24742 24623 24623 7032 7032
27621 27621 27429 27429 7032 7032

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