albums_labels

6 rows where label_id = 3901

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19943 19943 17774 17774 Menlo Park 3901
21817 21817 19454 19454 Menlo Park 3901
23772 23772 21268 21268 Menlo Park 3901
24102 24102 21582 21582 Menlo Park 3901
26247 26247 23627 23627 Menlo Park 3901
27247 27247 24564 24564 Menlo Park 3901

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