home / pf

albums_artists

13 rows where artist_id = 2450

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3055 3055 2880 2880 2450 2450
3555 3555 3358 3358 2450 2450
6316 6316 6030 6030 2450 2450
11042 11042 10701 10701 2450 2450
16946 16946 16638 16638 2450 2450
17912 17912 17619 17619 2450 2450
18467 18467 18199 18199 2450 2450
19510 19510 19297 19297 2450 2450
19995 19995 19810 19810 2450 2450
20977 20977 20831 20831 2450 2450
21882 21882 21778 21778 2450 2450
24667 24667 24544 24544 2450 2450
26077 26077 25974 25974 2450 2450

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