albums_labels

4 rows where label_id = 4017

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20650 20650 18398 18398 Camera Obscura 4017
21672 21672 19324 19324 Camera Obscura 4017
22508 22508 20087 20087 Camera Obscura 4017
25249 25249 22675 22675 Camera Obscura 4017

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