albums_labels

10 rows where label_id = 3851

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19692 19692 17538 17538 Le Grand Magistery 3851
21888 21888 19518 19518 Le Grand Magistery 3851
25627 25627 23034 23034 Le Grand Magistery 3851
26642 26642 24009 24009 Le Grand Magistery 3851
27951 27951 25224 25224 Le Grand Magistery 3851
28244 28244 25488 25488 Le Grand Magistery 3851
28471 28471 25699 25699 Le Grand Magistery 3851
28472 28472 25700 25700 Le Grand Magistery 3851
28992 28992 26166 26166 Le Grand Magistery 3851
29113 29113 26263 26263 Le Grand Magistery 3851

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