albums_labels

6 rows where label_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
49 49 44 44 Freedom to Spend 42
566 566 474 474 Freedom to Spend 42
4025 4025 3522 3522 Freedom to Spend 42
6319 6319 5503 5503 Freedom to Spend 42
6937 6937 6039 6039 Freedom to Spend 42
7359 7359 6398 6398 Freedom to Spend 42

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