albums_labels

9 rows where label_id = 904

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2151 2151 1870 1870 Constellation 904
3548 3548 3096 3096 Constellation 904
4001 4001 3499 3499 Constellation 904
4177 4177 3655 3655 Constellation 904
4645 4645 4054 4054 Constellation 904
4811 4811 4202 4202 Constellation 904
5568 5568 4846 4846 Constellation 904
6506 6506 5660 5660 Constellation 904
7036 7036 6126 6126 Constellation 904

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