albums_labels

9 rows where label_id = 83

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
95 95 86 86 CMG 83
279 279 243 243 CMG 83
533 533 447 447 CMG 83
910 910 778 778 CMG 83
1104 1104 948 948 CMG 83
2056 2056 1792 1792 CMG 83
3101 3101 2710 2710 CMG 83
29407 29407 26513 26513 CMG 83
29882 29882 26925 26925 CMG 83

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