albums_labels

4 rows where label_id = 3040

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13749 13749 12112 12112 Finders Keepers 3040
14348 14348 12669 12669 Finders Keepers 3040
14968 14968 13217 13217 Finders Keepers 3040
23557 23557 21069 21069 Finders Keepers 3040

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