albums_labels

10 rows where label_id = 594

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1141 1141 980 980 Awesome Tapes From Africa 594
1551 1551 1344 1344 Awesome Tapes From Africa 594
1818 1818 1592 1592 Awesome Tapes From Africa 594
3415 3415 2986 2986 Awesome Tapes From Africa 594
5682 5682 4946 4946 Awesome Tapes From Africa 594
6438 6438 5602 5602 Awesome Tapes From Africa 594
9366 9366 8189 8189 Awesome Tapes From Africa 594
11453 11453 10018 10018 Awesome Tapes From Africa 594
13055 13055 11471 11471 Awesome Tapes From Africa 594
13569 13569 11949 11949 Awesome Tapes From Africa 594

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