albums_labels

5 rows where label_id = 3992

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20501 20501 18264 18264 Source 3992
25144 25144 22572 22572 Source 3992
25380 25380 22801 22801 Source 3992
28368 28368 25605 25605 Source 3992
28457 28457 25687 25687 Source 3992

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