albums_labels

6 rows where label_id = 1280

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3530 3530 3083 3083 Machine Entertainment Group 1280
4648 4648 4057 4057 Machine Entertainment Group 1280
5766 5766 5018 5018 Machine Entertainment Group 1280
6247 6247 5440 5440 Machine Entertainment Group 1280
6909 6909 6018 6018 Machine Entertainment Group 1280
9868 9868 8631 8631 Machine Entertainment Group 1280

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