albums_labels

5 rows where label_id = 1648

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5146 5146 4500 4500 Lauren 1648
5148 5148 4501 4501 Lauren 1648
5150 5150 4502 4502 Lauren 1648
7651 7651 6662 6662 Lauren 1648
8738 8738 7622 7622 Lauren 1648

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