albums_labels

6 rows where label_id = 2779

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11840 11840 10361 10361 429 2779
13702 13702 12070 12070 429 2779
17679 17679 15626 15626 429 2779
19010 19010 16863 16863 429 2779
19591 19591 17438 17438 429 2779
21790 21790 19430 19430 429 2779

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