albums_labels

15 rows where label_id = 242

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
360 360 308 308 Telephone Explosion 242
668 668 561 561 Telephone Explosion 242
857 857 728 728 Telephone Explosion 242
1030 1030 882 882 Telephone Explosion 242
1067 1067 914 914 Telephone Explosion 242
1550 1550 1343 1343 Telephone Explosion 242
2214 2214 1927 1927 Telephone Explosion 242
2244 2244 1954 1954 Telephone Explosion 242
2492 2492 2174 2174 Telephone Explosion 242
2538 2538 2210 2210 Telephone Explosion 242
2827 2827 2465 2465 Telephone Explosion 242
3194 3194 2793 2793 Telephone Explosion 242
3744 3744 3265 3265 Telephone Explosion 242
6850 6850 5970 5970 Telephone Explosion 242
29571 29571 26660 26660 Telephone Explosion 242

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