albums_labels

12 rows where label_id = 3282

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15636 15636 13809 13809 Kitsuné 3282
16481 16481 14552 14552 Kitsuné 3282
17312 17312 15301 15301 Kitsuné 3282
17877 17877 15810 15810 Kitsuné 3282
18563 18563 16454 16454 Kitsuné 3282
18663 18663 16546 16546 Kitsuné 3282
19221 19221 17074 17074 Kitsuné 3282
19511 19511 17361 17361 Kitsuné 3282
20402 20402 18169 18169 Kitsuné 3282
20403 20403 18170 18170 Kitsuné 3282
21271 21271 18960 18960 Kitsuné 3282
21879 21879 19509 19509 Kitsuné 3282

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