albums_labels

10 rows where label_id = 3190

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14844 14844 13114 13114 Post Present Medium 3190
15163 15163 13394 13394 Post Present Medium 3190
15882 15882 14022 14022 Post Present Medium 3190
16550 16550 14617 14617 Post Present Medium 3190
16879 16879 14910 14910 Post Present Medium 3190
17611 17611 15559 15559 Post Present Medium 3190
18329 18329 16235 16235 Post Present Medium 3190
18688 18688 16570 16570 Post Present Medium 3190
18985 18985 16838 16838 Post Present Medium 3190
19753 19753 17598 17598 Post Present Medium 3190

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