albums_labels

12 rows where label_id = 622

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1228 1228 1058 1058 Ostgut Ton 622
3693 3693 3220 3220 Ostgut Ton 622
3804 3804 3321 3321 Ostgut Ton 622
4144 4144 3628 3628 Ostgut Ton 622
4984 4984 4353 4353 Ostgut Ton 622
7539 7539 6563 6563 Ostgut Ton 622
11070 11070 9688 9688 Ostgut Ton 622
16861 16861 14893 14893 Ostgut Ton 622
16985 16985 15005 15005 Ostgut Ton 622
17360 17360 15337 15337 Ostgut Ton 622
17646 17646 15593 15593 Ostgut Ton 622
18851 18851 16715 16715 Ostgut Ton 622

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