albums_labels

14 rows where label_id = 394

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
653 653 548 548 Pinkflag 394
7750 7750 6746 6746 Pinkflag 394
9169 9169 8020 8020 Pinkflag 394
10619 10619 9294 9294 Pinkflag 394
11527 11527 10084 10084 Pinkflag 394
13406 13406 11799 11799 Pinkflag 394
15003 15003 13248 13248 Pinkflag 394
16484 16484 14555 14555 Pinkflag 394
19758 19758 17603 17603 Pinkflag 394
20652 20652 18400 18400 Pinkflag 394
24730 24730 22170 22170 Pinkflag 394
26572 26572 23939 23939 Pinkflag 394
27140 27140 24468 24468 Pinkflag 394
27424 27424 24733 24733 Pinkflag 394

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