albums_labels

7 rows where label_id = 2465

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9660 9660 8448 8448 Iron Lung 2465
10014 10014 8759 8759 Iron Lung 2465
10304 10304 9017 9017 Iron Lung 2465
11706 11706 10248 10248 Iron Lung 2465
12991 12991 11413 11413 Iron Lung 2465
15111 15111 13346 13346 Iron Lung 2465
30265 30265 27272 27272 Iron Lung 2465

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