albums_labels

6 rows where label_id = 600

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1152 1152 991 991 Yellowelectric 600
5002 5002 4370 4370 Yellowelectric 600
13746 13746 12109 12109 Yellowelectric 600
14726 14726 13005 13005 Yellowelectric 600
16090 16090 14207 14207 Yellowelectric 600
16091 16091 14208 14208 Yellowelectric 600

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