home / pf

albums_labels

19 rows where label_id = 1207

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3257 3257 2850 2850 Ribbon Music 1207
4164 4164 3645 3645 Ribbon Music 1207
6197 6197 5394 5394 Ribbon Music 1207
6563 6563 5710 5710 Ribbon Music 1207
6865 6865 5982 5982 Ribbon Music 1207
9397 9397 8216 8216 Ribbon Music 1207
10558 10558 9241 9241 Ribbon Music 1207
10689 10689 9356 9356 Ribbon Music 1207
10716 10716 9380 9380 Ribbon Music 1207
11791 11791 10322 10322 Ribbon Music 1207
12604 12604 11060 11060 Ribbon Music 1207
13171 13171 11579 11579 Ribbon Music 1207
13636 13636 12009 12009 Ribbon Music 1207
14179 14179 12504 12504 Ribbon Music 1207
14346 14346 12667 12667 Ribbon Music 1207
14652 14652 12943 12943 Ribbon Music 1207
14728 14728 13007 13007 Ribbon Music 1207
15514 15514 13707 13707 Ribbon Music 1207
15757 15757 13911 13911 Ribbon Music 1207

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