home / pf

albums_labels

8 rows where label_id = 2266

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8433 8433 7347 7347 Cuneiform 2266
16963 16963 14984 14984 Cuneiform 2266
18833 18833 16697 16697 Cuneiform 2266
20746 20746 18484 18484 Cuneiform 2266
22905 22905 20450 20450 Cuneiform 2266
25063 25063 22499 22499 Cuneiform 2266
26150 26150 23535 23535 Cuneiform 2266
27021 27021 24361 24361 Cuneiform 2266

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