home / pf

albums_labels

30 rows where label_id = 580

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1108 1108 952 952 Moshi Moshi 580
3052 3052 2672 2672 Moshi Moshi 580
4960 4960 4334 4334 Moshi Moshi 580
5663 5663 4928 4928 Moshi Moshi 580
8697 8697 7584 7584 Moshi Moshi 580
8974 8974 7835 7835 Moshi Moshi 580
9335 9335 8161 8161 Moshi Moshi 580
9400 9400 8218 8218 Moshi Moshi 580
10606 10606 9283 9283 Moshi Moshi 580
10859 10859 9505 9505 Moshi Moshi 580
12637 12637 11093 11093 Moshi Moshi 580
12711 12711 11160 11160 Moshi Moshi 580
12853 12853 11289 11289 Moshi Moshi 580
13924 13924 12271 12271 Moshi Moshi 580
14351 14351 12672 12672 Moshi Moshi 580
15214 15214 13440 13440 Moshi Moshi 580
15497 15497 13693 13693 Moshi Moshi 580
15500 15500 13695 13695 Moshi Moshi 580
16008 16008 14132 14132 Moshi Moshi 580
16413 16413 14494 14494 Moshi Moshi 580
17094 17094 15108 15108 Moshi Moshi 580
17245 17245 15241 15241 Moshi Moshi 580
17388 17388 15362 15362 Moshi Moshi 580
17389 17389 15363 15363 Moshi Moshi 580
17656 17656 15603 15603 Moshi Moshi 580
18637 18637 16523 16523 Moshi Moshi 580
20375 20375 18146 18146 Moshi Moshi 580
21663 21663 19316 19316 Moshi Moshi 580
22498 22498 20077 20077 Moshi Moshi 580
29825 29825 26876 26876 Moshi Moshi 580

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 64.402ms