home / pf

albums_artists

6 rows where artist_id = 7006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13080 13080 12743 12743 7006 7006
18039 18039 17749 17749 7006 7006
19152 19152 18930 18930 7006 7006
23716 23716 23607 23607 7006 7006
24669 24669 24546 24546 7006 7006
26252 26252 26150 26150 7006 7006

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