albums_labels

9 rows where label_id = 2945

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12878 12878 11311 11311 Full Time Hobby 2945
14265 14265 12589 12589 Full Time Hobby 2945
16172 16172 14278 14278 Full Time Hobby 2945
17506 17506 15469 15469 Full Time Hobby 2945
18450 18450 16351 16351 Full Time Hobby 2945
18480 18480 16379 16379 Full Time Hobby 2945
20542 20542 18301 18301 Full Time Hobby 2945
22599 22599 20171 20171 Full Time Hobby 2945
23513 23513 21026 21026 Full Time Hobby 2945

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