albums_labels

5 rows where label_id = 2799

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11943 11943 10451 10451 Glitterhouse 2799
26008 26008 23398 23398 Glitterhouse 2799
26009 26009 23399 23399 Glitterhouse 2799
26010 26010 23400 23400 Glitterhouse 2799
27771 27771 25055 25055 Glitterhouse 2799

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