home / pf

albums_labels

9 rows where label_id = 652

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1334 1334 1148 1148 Luminelle 652
1479 1479 1281 1281 Luminelle 652
2650 2650 2311 2311 Luminelle 652
3466 3466 3029 3029 Luminelle 652
3990 3990 3488 3488 Luminelle 652
4348 4348 3797 3797 Luminelle 652
4691 4691 4094 4094 Luminelle 652
5403 5403 4704 4704 Luminelle 652
5855 5855 5103 5103 Luminelle 652

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