albums_labels

12 rows where label_id = 1330

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3747 3747 3268 3268 On-U Sound 1330
4565 4565 3986 3986 On-U Sound 1330
7893 7893 6870 6870 On-U Sound 1330
9282 9282 8116 8116 On-U Sound 1330
9511 9511 8316 8316 On-U Sound 1330
9538 9538 8340 8340 On-U Sound 1330
9539 9539 8341 8341 On-U Sound 1330
9540 9540 8342 8342 On-U Sound 1330
9541 9541 8343 8343 On-U Sound 1330
10431 10431 9126 9126 On-U Sound 1330
10614 10614 9289 9289 On-U Sound 1330
10909 10909 9548 9548 On-U Sound 1330

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