home / pf

albums_artists

6 rows where artist_id = 2260

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2737 2737 2574 2574 2260 2260
2738 2738 2575 2575 2260 2260
2739 2739 2576 2576 2260 2260
19539 19539 19326 19326 2260 2260
22484 22484 22388 22388 2260 2260
22650 22650 22557 22557 2260 2260

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