home / pf

albums_labels

11 rows where label_id = 115

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
131 131 113 113 Keeled Scales 115
167 167 143 143 Keeled Scales 115
429 429 366 366 Keeled Scales 115
891 891 762 762 Keeled Scales 115
2159 2159 1877 1877 Keeled Scales 115
2360 2360 2052 2052 Keeled Scales 115
2412 2412 2100 2100 Keeled Scales 115
3153 3153 2757 2757 Keeled Scales 115
4523 4523 3947 3947 Keeled Scales 115
6070 6070 5281 5281 Keeled Scales 115
30031 30031 27059 27059 Keeled Scales 115

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