albums_labels

10 rows where label_id = 2289

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8573 8573 7476 7476 Control Group 2289
11772 11772 10304 10304 Control Group 2289
13861 13861 12216 12216 Control Group 2289
15085 15085 13321 13321 Control Group 2289
16051 16051 14173 14173 Control Group 2289
17270 17270 15265 15265 Control Group 2289
18543 18543 16437 16437 Control Group 2289
20314 20314 18091 18091 Control Group 2289
21008 21008 18721 18721 Control Group 2289
22854 22854 20406 20406 Control Group 2289

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