home / pf

albums_labels

6 rows where label_id = 2690

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11206 11206 9804 9804 Glacial Pace 2690
11209 11209 9805 9805 Glacial Pace 2690
11949 11949 10456 10456 Glacial Pace 2690
16651 16651 14700 14700 Glacial Pace 2690
16653 16653 14701 14701 Glacial Pace 2690
17528 17528 15490 15490 Glacial Pace 2690

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);
Powered by Datasette · Queries took 70.321ms