albums_labels

7 rows where label_id = 2074

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7357 7357 6396 6396 Translation Loss 2074
11074 11074 9690 9690 Translation Loss 2074
12182 12182 10668 10668 Translation Loss 2074
12931 12931 11359 11359 Translation Loss 2074
12935 12935 11363 11363 Translation Loss 2074
14681 14681 12966 12966 Translation Loss 2074
20222 20222 18009 18009 Translation Loss 2074

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