home / pf

albums_labels

37 rows where label_id = 747

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1628 1628 1413 1413 Cooking Vinyl 747
2953 2953 2579 2579 Cooking Vinyl 747
3424 3424 2995 2995 Cooking Vinyl 747
3646 3646 3179 3179 Cooking Vinyl 747
4023 4023 3521 3521 Cooking Vinyl 747
4706 4706 4107 4107 Cooking Vinyl 747
6950 6950 6049 6049 Cooking Vinyl 747
8357 8357 7282 7282 Cooking Vinyl 747
8618 8618 7515 7515 Cooking Vinyl 747
9067 9067 7923 7923 Cooking Vinyl 747
9492 9492 8301 8301 Cooking Vinyl 747
10709 10709 9375 9375 Cooking Vinyl 747
14171 14171 12498 12498 Cooking Vinyl 747
15034 15034 13275 13275 Cooking Vinyl 747
15866 15866 14008 14008 Cooking Vinyl 747
15949 15949 14080 14080 Cooking Vinyl 747
16869 16869 14901 14901 Cooking Vinyl 747
17512 17512 15475 15475 Cooking Vinyl 747
17516 17516 15479 15479 Cooking Vinyl 747
17692 17692 15639 15639 Cooking Vinyl 747
18511 18511 16408 16408 Cooking Vinyl 747
18773 18773 16647 16647 Cooking Vinyl 747
19617 19617 17464 17464 Cooking Vinyl 747
20093 20093 17904 17904 Cooking Vinyl 747
20193 20193 17987 17987 Cooking Vinyl 747
20451 20451 18215 18215 Cooking Vinyl 747
20954 20954 18670 18670 Cooking Vinyl 747
21167 21167 18869 18869 Cooking Vinyl 747
22490 22490 20070 20070 Cooking Vinyl 747
22976 22976 20518 20518 Cooking Vinyl 747
23249 23249 20779 20779 Cooking Vinyl 747
23535 23535 21048 21048 Cooking Vinyl 747
23608 23608 21118 21118 Cooking Vinyl 747
27479 27479 24783 24783 Cooking Vinyl 747
28373 28373 25608 25608 Cooking Vinyl 747
28947 28947 26126 26126 Cooking Vinyl 747
29212 29212 26347 26347 Cooking Vinyl 747

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