albums_labels

10 rows where label_id = 4172

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21624 21624 19281 19281 ~scape 4172
21943 21943 19569 19569 ~scape 4172
23224 23224 20754 20754 ~scape 4172
23313 23313 20840 20840 ~scape 4172
24081 24081 21564 21564 ~scape 4172
24697 24697 22140 22140 ~scape 4172
25588 25588 22995 22995 ~scape 4172
25724 25724 23129 23129 ~scape 4172
26808 26808 24167 24167 ~scape 4172
28487 28487 25715 25715 ~scape 4172

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)
);