albums_labels

7 rows where label_id = 384

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
633 633 532 532 Crush 384
769 769 650 650 Crush 384
979 979 835 835 Crush 384
2005 2005 1749 1749 Crush 384
6876 6876 5992 5992 Crush 384
9295 9295 8127 8127 Crush 384
11852 11852 10371 10371 Crush 384

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