albums_labels

7 rows where label_id = 1762

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5797 5797 5049 5049 Music From Memory 1762
6267 6267 5457 5457 Music From Memory 1762
6509 6509 5663 5663 Music From Memory 1762
7884 7884 6863 6863 Music From Memory 1762
8727 8727 7612 7612 Music From Memory 1762
10495 10495 9185 9185 Music From Memory 1762
11016 11016 9648 9648 Music From Memory 1762

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