albums_labels

11 rows where label_id = 3006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13450 13450 11840 11840 Magic Marker 3006
16211 16211 14314 14314 Magic Marker 3006
17789 17789 15727 15727 Magic Marker 3006
19222 19222 17075 17075 Magic Marker 3006
21178 21178 18878 18878 Magic Marker 3006
21899 21899 19528 19528 Magic Marker 3006
23439 23439 20957 20957 Magic Marker 3006
24008 24008 21495 21495 Magic Marker 3006
24361 24361 21826 21826 Magic Marker 3006
24482 24482 21941 21941 Magic Marker 3006
24666 24666 22111 22111 Magic Marker 3006

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