albums_labels

6 rows where label_id = 2855

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12297 12297 10776 10776 HOSS 2855
15731 15731 13889 13889 HOSS 2855
19962 19962 17791 17791 HOSS 2855
20296 20296 18074 18074 HOSS 2855
20422 20422 18187 18187 HOSS 2855
22213 22213 19821 19821 HOSS 2855

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