albums_labels

5 rows where label_id = 437

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
752 752 637 637 Dog Knights 437
2444 2444 2129 2129 Dog Knights 437
3032 3032 2653 2653 Dog Knights 437
3231 3231 2826 2826 Dog Knights 437
4615 4615 4028 4028 Dog Knights 437

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