home / pf

albums_artists

20 rows where artist_id = 246

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
252 252 241 241 246 246
3255 3255 3072 3072 246 246
6164 6164 5885 5885 246 246
7262 7262 6965 6965 246 246
8913 8913 8577 8577 246 246
9959 9959 9614 9614 246 246
12485 12485 12147 12147 246 246
13956 13956 13599 13599 246 246
15483 15483 15141 15141 246 246
16649 16649 16339 16339 246 246
19306 19306 19088 19088 246 246
20217 20217 20041 20041 246 246
21354 21354 21231 21231 246 246
22552 22552 22458 22458 246 246
22817 22817 22726 22726 246 246
22818 22818 22727 22727 246 246
22819 22819 22728 22728 246 246
22820 22820 22729 22729 246 246
25631 25631 25533 25533 246 246
25945 25945 25846 25846 246 246

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.512ms