albums_labels

7 rows where label_id = 2379

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9092 9092 7949 7949 Pax-Am 2379
9990 9990 8737 8737 Pax-Am 2379
10596 10596 9275 9275 Pax-Am 2379
11434 11434 10001 10001 Pax-Am 2379
11435 11435 10002 10002 Pax-Am 2379
15402 15402 13609 13609 Pax-Am 2379
16519 16519 14589 14589 Pax-Am 2379

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