home / pf

albums_artists

5 rows where artist_id = 6440

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11622 11622 11285 11285 6440 6440
11623 11623 11286 11286 6440 6440
11624 11624 11287 11287 6440 6440
12853 12853 12510 12510 6440 6440
22417 22417 22322 22322 6440 6440

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