albums_labels

5 rows where label_id = 1645

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5142 5142 4498 4498 Slaughter Gang 1645
6836 6836 5961 5961 Slaughter Gang 1645
7344 7344 6386 6386 Slaughter Gang 1645
8804 8804 7684 7684 Slaughter Gang 1645
30271 30271 27278 27278 Slaughter Gang 1645

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