albums_labels

5 rows where label_id = 448

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
777 777 658 658 Royal Mountain 448
945 945 806 806 Royal Mountain 448
1878 1878 1641 1641 Royal Mountain 448
2306 2306 2006 2006 Royal Mountain 448
3513 3513 3068 3068 Royal Mountain 448

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