home / pf

albums_labels

15 rows where label_id = 859

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2022 2022 1763 1763 Omnivore 859
3719 3719 3241 3241 Omnivore 859
4014 4014 3512 3512 Omnivore 859
7032 7032 6122 6122 Omnivore 859
7131 7131 6208 6208 Omnivore 859
8449 8449 7362 7362 Omnivore 859
8631 8631 7526 7526 Omnivore 859
9045 9045 7901 7901 Omnivore 859
11470 11470 10033 10033 Omnivore 859
12205 12205 10689 10689 Omnivore 859
13006 13006 11427 11427 Omnivore 859
13046 13046 11462 11462 Omnivore 859
13047 13047 11463 11463 Omnivore 859
13048 13048 11464 11464 Omnivore 859
15121 15121 13355 13355 Omnivore 859

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