albums_labels

8 rows where label_id = 1205

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3243 3243 2837 2837 Beats in Space 1205
3683 3683 3214 3214 Beats in Space 1205
4996 4996 4364 4364 Beats in Space 1205
6009 6009 5241 5241 Beats in Space 1205
6401 6401 5572 5572 Beats in Space 1205
9207 9207 8051 8051 Beats in Space 1205
10752 10752 9409 9409 Beats in Space 1205
13210 13210 11617 11617 Beats in Space 1205

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