albums_labels

12 rows where label_id = 94

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
108 108 96 96 Bayonet 94
630 630 529 529 Bayonet 94
1122 1122 964 964 Bayonet 94
1749 1749 1525 1525 Bayonet 94
2296 2296 1998 1998 Bayonet 94
3552 3552 3099 3099 Bayonet 94
7476 7476 6505 6505 Bayonet 94
8432 8432 7346 7346 Bayonet 94
9285 9285 8119 8119 Bayonet 94
9793 9793 8567 8567 Bayonet 94
29637 29637 26715 26715 Bayonet 94
29770 29770 26829 26829 Bayonet 94

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