albums_labels

7 rows where label_id = 4066

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20991 20991 18705 18705 Fading Captain 4066
22694 22694 20255 20255 Fading Captain 4066
22695 22695 20256 20256 Fading Captain 4066
22696 22696 20257 20257 Fading Captain 4066
23452 23452 20970 20970 Fading Captain 4066
26732 26732 24095 24095 Fading Captain 4066
27787 27787 25071 25071 Fading Captain 4066

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