albums_labels

12 rows where label_id = 3799

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19427 19427 17278 17278 Warm 3799
20267 20267 18048 18048 Warm 3799
22169 22169 19782 19782 Warm 3799
22724 22724 20283 20283 Warm 3799
24411 24411 21872 21872 Warm 3799
27252 27252 24568 24568 Warm 3799
27553 27553 24854 24854 Warm 3799
28047 28047 25311 25311 Warm 3799
28154 28154 25405 25405 Warm 3799
28461 28461 25690 25690 Warm 3799
28463 28463 25691 25691 Warm 3799
28869 28869 26058 26058 Warm 3799

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