albums_labels

4 rows where label_id = 1436

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4221 4221 3690 3690 Elephant Six 1436
17438 17438 15405 15405 Elephant Six 1436
20159 20159 17958 17958 Elephant Six 1436
28722 28722 25925 25925 Elephant Six 1436

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