home / pf

albums_labels

13 rows where label_id = 574

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1098 1098 943 943 Modern Love 574
2091 2091 1819 1819 Modern Love 574
2506 2506 2185 2185 Modern Love 574
3903 3903 3411 3411 Modern Love 574
5298 5298 4616 4616 Modern Love 574
8235 8235 7175 7175 Modern Love 574
9183 9183 8030 8030 Modern Love 574
13961 13961 12306 12306 Modern Love 574
13988 13988 12327 12327 Modern Love 574
15116 15116 13351 13351 Modern Love 574
15335 15335 13547 13547 Modern Love 574
15959 15959 14089 14089 Modern Love 574
16402 16402 14484 14484 Modern Love 574

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