albums_labels

10 rows where label_id = 913

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2190 2190 1906 1906 Ernest Jenning 913
3135 3135 2740 2740 Ernest Jenning 913
6932 6932 6034 6034 Ernest Jenning 913
8776 8776 7659 7659 Ernest Jenning 913
14004 14004 12341 12341 Ernest Jenning 913
15943 15943 14076 14076 Ernest Jenning 913
16085 16085 14202 14202 Ernest Jenning 913
17728 17728 15670 15670 Ernest Jenning 913
18764 18764 16640 16640 Ernest Jenning 913
29233 29233 26366 26366 Ernest Jenning 913

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