albums_labels

6 rows where label_id = 1332

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3752 3752 3273 3273 Trip 1332
3946 3946 3448 3448 Trip 1332
4206 4206 3679 3679 Trip 1332
4367 4367 3812 3812 Trip 1332
4482 4482 3913 3913 Trip 1332
8901 8901 7772 7772 Trip 1332

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