albums_labels

7 rows where label_id = 3785

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19348 19348 17200 17200 ROIR 3785
22479 22479 20060 20060 ROIR 3785
22807 22807 20362 20362 ROIR 3785
23405 23405 20927 20927 ROIR 3785
24901 24901 22337 22337 ROIR 3785
26803 26803 24162 24162 ROIR 3785
26973 26973 24318 24318 ROIR 3785

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