albums_labels

14 rows where label_id = 2407

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9303 9303 8133 8133 Monkeytown 2407
10207 10207 8932 8932 Monkeytown 2407
11104 11104 9719 9719 Monkeytown 2407
11502 11502 10063 10063 Monkeytown 2407
12405 12405 10877 10877 Monkeytown 2407
12940 12940 11367 11367 Monkeytown 2407
13928 13928 12275 12275 Monkeytown 2407
14420 14420 12737 12737 Monkeytown 2407
14614 14614 12911 12911 Monkeytown 2407
14928 14928 13182 13182 Monkeytown 2407
15436 15436 13639 13639 Monkeytown 2407
15720 15720 13878 13878 Monkeytown 2407
16224 16224 14325 14325 Monkeytown 2407
16483 16483 14554 14554 Monkeytown 2407

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