albums_labels

4 rows where label_id = 3878

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19790 19790 17632 17632 75 Arkz 3878
27981 27981 25251 25251 75 Arkz 3878
27985 27985 25255 25255 75 Arkz 3878
28856 28856 26046 26046 75 Arkz 3878

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