albums_labels

6 rows where label_id = 887

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2102 2102 1830 1830 Ministry of Sound 887
13041 13041 11456 11456 Ministry of Sound 887
14560 14560 12860 12860 Ministry of Sound 887
18469 18469 16369 16369 Ministry of Sound 887
26952 26952 24298 24298 Ministry of Sound 887
27410 27410 24720 24720 Ministry of Sound 887

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