home / pf

albums_labels

32 rows where label_id = 167

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
216 216 185 185 Erased Tapes 167
1090 1090 935 935 Erased Tapes 167
2497 2497 2178 2178 Erased Tapes 167
2885 2885 2517 2517 Erased Tapes 167
3553 3553 3100 3100 Erased Tapes 167
3839 3839 3354 3354 Erased Tapes 167
4002 4002 3500 3500 Erased Tapes 167
5757 5757 5012 5012 Erased Tapes 167
6571 6571 5717 5717 Erased Tapes 167
7588 7588 6604 6604 Erased Tapes 167
7746 7746 6742 6742 Erased Tapes 167
8103 8103 7057 7057 Erased Tapes 167
8165 8165 7114 7114 Erased Tapes 167
8658 8658 7548 7548 Erased Tapes 167
8736 8736 7620 7620 Erased Tapes 167
8864 8864 7738 7738 Erased Tapes 167
9367 9367 8190 8190 Erased Tapes 167
9704 9704 8488 8488 Erased Tapes 167
9863 9863 8627 8627 Erased Tapes 167
10087 10087 8826 8826 Erased Tapes 167
10371 10371 9075 9075 Erased Tapes 167
10659 10659 9329 9329 Erased Tapes 167
11284 11284 9870 9870 Erased Tapes 167
12348 12348 10822 10822 Erased Tapes 167
14957 14957 13208 13208 Erased Tapes 167
14958 14958 13209 13209 Erased Tapes 167
15510 15510 13703 13703 Erased Tapes 167
17230 17230 15228 15228 Erased Tapes 167
17353 17353 15331 15331 Erased Tapes 167
17701 17701 15648 15648 Erased Tapes 167
18365 18365 16270 16270 Erased Tapes 167
29765 29765 26825 26825 Erased Tapes 167

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)
);
Powered by Datasette · Queries took 63.868ms