albums_labels

19 rows where label_id = 191

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
256 256 221 221 Fire Talk 191
484 484 410 410 Fire Talk 191
742 742 628 628 Fire Talk 191
1347 1347 1162 1162 Fire Talk 191
1603 1603 1392 1392 Fire Talk 191
2504 2504 2183 2183 Fire Talk 191
2992 2992 2617 2617 Fire Talk 191
3275 3275 2864 2864 Fire Talk 191
3868 3868 3381 3381 Fire Talk 191
4085 4085 3578 3578 Fire Talk 191
4625 4625 4037 4037 Fire Talk 191
4760 4760 4155 4155 Fire Talk 191
5987 5987 5221 5221 Fire Talk 191
12291 12291 10770 10770 Fire Talk 191
16384 16384 14467 14467 Fire Talk 191
29391 29391 26501 26501 Fire Talk 191
29592 29592 26678 26678 Fire Talk 191
29792 29792 26848 26848 Fire Talk 191
30287 30287 27291 27291 Fire Talk 191

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