albums_labels

8 rows where label_id = 1177

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3116 3116 2722 2722 Tectonic 1177
7892 7892 6870 6870 Tectonic 1177
10908 10908 9548 9548 Tectonic 1177
12471 12471 10941 10941 Tectonic 1177
13221 13221 11628 11628 Tectonic 1177
14567 14567 12867 12867 Tectonic 1177
16503 16503 14573 14573 Tectonic 1177
18032 18032 15957 15957 Tectonic 1177

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