home / pf

albums_artists

5 rows where artist_id = 7677

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14981 14981 14631 14631 7677 7677
14982 14982 14632 14632 7677 7677
14983 14983 14633 14633 7677 7677
15454 15454 15112 15112 7677 7677
22244 22244 22154 22154 7677 7677

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