albums_labels

38 rows where label_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8 8 8 8 Leaving 7
225 225 193 193 Leaving 7
693 693 583 583 Leaving 7
806 806 680 680 Leaving 7
871 871 743 743 Leaving 7
1077 1077 922 922 Leaving 7
1739 1739 1515 1515 Leaving 7
2018 2018 1759 1759 Leaving 7
2267 2267 1973 1973 Leaving 7
2476 2476 2158 2158 Leaving 7
3144 3144 2749 2749 Leaving 7
3320 3320 2901 2901 Leaving 7
4310 4310 3763 3763 Leaving 7
4731 4731 4129 4129 Leaving 7
4993 4993 4361 4361 Leaving 7
5235 5235 4569 4569 Leaving 7
5490 5490 4778 4778 Leaving 7
6181 6181 5378 5378 Leaving 7
6584 6584 5729 5729 Leaving 7
8014 8014 6977 6977 Leaving 7
8139 8139 7089 7089 Leaving 7
8268 8268 7206 7206 Leaving 7
8532 8532 7438 7438 Leaving 7
8886 8886 7757 7757 Leaving 7
9012 9012 7873 7873 Leaving 7
9208 9208 8052 8052 Leaving 7
9626 9626 8420 8420 Leaving 7
9688 9688 8473 8473 Leaving 7
10183 10183 8910 8910 Leaving 7
10184 10184 8911 8911 Leaving 7
10185 10185 8912 8912 Leaving 7
10481 10481 9172 9172 Leaving 7
11280 11280 9867 9867 Leaving 7
11718 11718 10257 10257 Leaving 7
13625 13625 11999 11999 Leaving 7
14861 14861 13125 13125 Leaving 7
15369 15369 13578 13578 Leaving 7
30067 30067 27090 27090 Leaving 7

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