albums_labels

7 rows where label_id = 492

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
884 884 756 756 Escho 492
7507 7507 6533 6533 Escho 492
10079 10079 8818 8818 Escho 492
12509 12509 10974 10974 Escho 492
14457 14457 12769 12769 Escho 492
15761 15761 13913 13913 Escho 492
30292 30292 27296 27296 Escho 492

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