albums_labels

17 rows where label_id = 3438

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16780 16780 14818 14818 Narnack 3438
18080 18080 16003 16003 Narnack 3438
19050 19050 16903 16903 Narnack 3438
21640 21640 19296 19296 Narnack 3438
21739 21739 19387 19387 Narnack 3438
22478 22478 20059 20059 Narnack 3438
22502 22502 20081 20081 Narnack 3438
22589 22589 20161 20161 Narnack 3438
23250 23250 20780 20780 Narnack 3438
23546 23546 21060 21060 Narnack 3438
24523 24523 21980 21980 Narnack 3438
24609 24609 22057 22057 Narnack 3438
24985 24985 22421 22421 Narnack 3438
25051 25051 22487 22487 Narnack 3438
25442 25442 22859 22859 Narnack 3438
25871 25871 23269 23269 Narnack 3438
26765 26765 24126 24126 Narnack 3438

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