albums_labels

5 rows where label_id = 2279

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8516 8516 7425 7425 Cinematic 2279
8903 8903 7774 7774 Cinematic 2279
9808 9808 8580 8580 Cinematic 2279
10127 10127 8861 8861 Cinematic 2279
14368 14368 12687 12687 Cinematic 2279

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