home / pf

albums_artists

16 rows where artist_id = 239

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
245 245 235 235 239 239
1811 1811 1711 1711 239 239
4430 4430 4217 4217 239 239
5220 5220 4975 4975 239 239
7596 7596 7289 7289 239 239
11137 11137 10799 10799 239 239
13543 13543 13192 13192 239 239
17577 17577 17281 17281 239 239
20118 20118 19941 19941 239 239
20565 20565 20404 20404 239 239
20566 20566 20405 20405 239 239
23194 23194 23091 23091 239 239
24586 24586 24464 24464 239 239
25197 25197 25092 25092 239 239
25592 25592 25494 25494 239 239
25897 25897 25799 25799 239 239

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