albums_labels

8 rows where label_id = 3057

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13838 13838 12194 12194 HoZac 3057
15496 15496 13692 13692 HoZac 3057
15986 15986 14112 14112 HoZac 3057
16559 16559 14625 14625 HoZac 3057
16564 16564 14628 14628 HoZac 3057
17326 17326 15312 15312 HoZac 3057
17531 17531 15492 15492 HoZac 3057
18346 18346 16252 16252 HoZac 3057

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