albums_labels

7 rows where label_id = 1006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2472 2472 2154 2154 Grapefruit 1006
5695 5695 4956 4956 Grapefruit 1006
8376 8376 7298 7298 Grapefruit 1006
8377 8377 7299 7299 Grapefruit 1006
8378 8378 7300 7300 Grapefruit 1006
8379 8379 7301 7301 Grapefruit 1006
8380 8380 7302 7302 Grapefruit 1006

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