albums_labels

9 rows where label_id = 3731

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19039 19039 16892 16892 Homestead 3731
19040 19040 16893 16893 Homestead 3731
21128 21128 18832 18832 Homestead 3731
22408 22408 19996 19996 Homestead 3731
23207 23207 20738 20738 Homestead 3731
23208 23208 20739 20739 Homestead 3731
24257 24257 21728 21728 Homestead 3731
24258 24258 21729 21729 Homestead 3731
24259 24259 21730 21730 Homestead 3731

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