albums_labels

4 rows where label_id = 309

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
491 491 415 415 YBNL Nation 309
1788 1788 1561 1561 YBNL Nation 309
2862 2862 2498 2498 YBNL Nation 309
29682 29682 26754 26754 YBNL Nation 309

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