albums_labels

5 rows where label_id = 2193

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8040 8040 7000 7000 Doomtree 2193
10968 10968 9603 9603 Doomtree 2193
15209 15209 13435 13435 Doomtree 2193
16560 16560 14626 14626 Doomtree 2193
19570 19570 17417 17417 Doomtree 2193

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