albums_labels

4 rows where label_id = 4052

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20885 20885 18607 18607 Sonic Boom 4052
21578 21578 19238 19238 Sonic Boom 4052
24801 24801 22238 22238 Sonic Boom 4052
25402 25402 22821 22821 Sonic Boom 4052

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