home / pf

albums_artists

6 rows where artist_id = 6392

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11497 11497 11160 11160 6392 6392
15450 15450 15108 15108 6392 6392
16832 16832 16523 16523 6392 6392
17324 17324 17022 17022 6392 6392
19529 19529 19316 19316 6392 6392
20252 20252 20077 20077 6392 6392

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