home / pf

albums_labels

7 rows where label_id = 259

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
392 392 334 334 Infiné 259
4441 4441 3878 3878 Infiné 259
10406 10406 9104 9104 Infiné 259
10915 10915 9553 9553 Infiné 259
11378 11378 9953 9953 Infiné 259
12030 12030 10530 10530 Infiné 259
17727 17727 15669 15669 Infiné 259

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