home / pf

albums_artists

7 rows where artist_id = 4735

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7655 7655 7349 7349 4735 4735
12275 12275 11938 11938 4735 4735
15639 15639 15300 15300 4735 4735
18140 18140 17856 17856 4735 4735
20393 20393 20226 20226 4735 4735
21536 21536 21416 21416 4735 4735
25851 25851 25752 25752 4735 4735

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