home / pf

albums_labels

7 rows where label_id = 451

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
785 785 666 666 Artium 451
1757 1757 1532 1532 Artium 451
4183 4183 3661 3661 Artium 451
8637 8637 7529 7529 Artium 451
11439 11439 10005 10005 Artium 451
11606 11606 10155 10155 Artium 451
12495 12495 10961 10961 Artium 451

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