albums_labels

8 rows where label_id = 2381

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9121 9121 7977 7977 Sky 2381
9122 9122 7978 7978 Sky 2381
22882 22882 20429 20429 Sky 2381
22883 22883 20430 20430 Sky 2381
23668 23668 21171 21171 Sky 2381
23669 23669 21172 21172 Sky 2381
23670 23670 21173 21173 Sky 2381
26093 26093 23481 23481 Sky 2381

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