albums_labels

4 rows where label_id = 4289

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22443 22443 20028 20028 Secret Eye 4289
23131 23131 20662 20662 Secret Eye 4289
23153 23153 20684 20684 Secret Eye 4289
23829 23829 21325 21325 Secret Eye 4289

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