albums_labels

29 rows where label_id = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
54 54 49 49 Ghostly International 47
407 407 346 346 Ghostly International 47
535 535 448 448 Ghostly International 47
1417 1417 1225 1225 Ghostly International 47
2739 2739 2391 2391 Ghostly International 47
3033 3033 2654 2654 Ghostly International 47
3225 3225 2820 2820 Ghostly International 47
3845 3845 3359 3359 Ghostly International 47
4079 4079 3572 3572 Ghostly International 47
5437 5437 4735 4735 Ghostly International 47
6076 6076 5286 5286 Ghostly International 47
6427 6427 5595 5595 Ghostly International 47
6433 6433 5599 5599 Ghostly International 47
6816 6816 5942 5942 Ghostly International 47
7407 7407 6442 6442 Ghostly International 47
7695 7695 6699 6699 Ghostly International 47
8720 8720 7605 7605 Ghostly International 47
8721 8721 7606 7606 Ghostly International 47
9277 9277 8111 8111 Ghostly International 47
10177 10177 8904 8904 Ghostly International 47
10318 10318 9029 9029 Ghostly International 47
11917 11917 10428 10428 Ghostly International 47
12131 12131 10622 10622 Ghostly International 47
12197 12197 10682 10682 Ghostly International 47
12730 12730 11177 11177 Ghostly International 47
29295 29295 26423 26423 Ghostly International 47
29750 29750 26811 26811 Ghostly International 47
29907 29907 26945 26945 Ghostly International 47
30024 30024 27051 27051 Ghostly International 47

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