albums_labels

6 rows where label_id = 4481

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24156 24156 21632 21632 Tooth and Nail 4481
26022 26022 23412 23412 Tooth and Nail 4481
27465 27465 24771 24771 Tooth and Nail 4481
28492 28492 25719 25719 Tooth and Nail 4481
28908 28908 26094 26094 Tooth and Nail 4481
29139 29139 26286 26286 Tooth and Nail 4481

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