albums_labels

8 rows where label_id = 1504

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4531 4531 3955 3955 Jealous Butcher 1504
4532 4532 3956 3956 Jealous Butcher 1504
4533 4533 3957 3957 Jealous Butcher 1504
11008 11008 9640 9640 Jealous Butcher 1504
12934 12934 11362 11362 Jealous Butcher 1504
13685 13685 12054 12054 Jealous Butcher 1504
15030 15030 13271 13271 Jealous Butcher 1504
29632 29632 26710 26710 Jealous Butcher 1504

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