albums_labels

10 rows where label_id = 1966

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6752 6752 5881 5881 Kobalt 1966
7046 7046 6134 6134 Kobalt 1966
7983 7983 6948 6948 Kobalt 1966
10866 10866 9512 9512 Kobalt 1966
11287 11287 9873 9873 Kobalt 1966
11484 11484 10046 10046 Kobalt 1966
11721 11721 10260 10260 Kobalt 1966
12247 12247 10728 10728 Kobalt 1966
12256 12256 10735 10735 Kobalt 1966
12978 12978 11401 11401 Kobalt 1966

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