albums_labels

5 rows where label_id = 158

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
195 195 170 170 Schoolboy 158
4618 4618 4031 4031 Schoolboy 158
8597 8597 7498 7498 Schoolboy 158
10152 10152 8881 8881 Schoolboy 158
29816 29816 26868 26868 Schoolboy 158

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