albums_labels

5 rows where label_id = 639

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1266 1266 1091 1091 Oh Boy 639
1521 1521 1318 1318 Oh Boy 639
6222 6222 5417 5417 Oh Boy 639
17231 17231 15229 15229 Oh Boy 639
24635 24635 22081 22081 Oh Boy 639

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