albums_labels

5 rows where label_id = 1077

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2723 2723 2377 2377 Sound Signature 1077
8794 8794 7675 7675 Sound Signature 1077
8795 8795 7676 7676 Sound Signature 1077
11039 11039 9666 9666 Sound Signature 1077
19279 19279 17131 17131 Sound Signature 1077

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