albums_labels

17 rows where label_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
61 61 55 55 The Flenser 53
278 278 242 242 The Flenser 53
529 529 444 444 The Flenser 53
569 569 477 477 The Flenser 53
1773 1773 1546 1546 The Flenser 53
3267 3267 2858 2858 The Flenser 53
3924 3924 3429 3429 The Flenser 53
7377 7377 6415 6415 The Flenser 53
8816 8816 7694 7694 The Flenser 53
10808 10808 9459 9459 The Flenser 53
10822 10822 9471 9471 The Flenser 53
11890 11890 10406 10406 The Flenser 53
12288 12288 10768 10768 The Flenser 53
12708 12708 11157 11157 The Flenser 53
29582 29582 26670 26670 The Flenser 53
29915 29915 26953 26953 The Flenser 53
30095 30095 27116 27116 The Flenser 53

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