home / pf

albums_labels

22 rows where label_id = 68

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
78 78 70 70 Because Music 68
258 258 223 223 Because Music 68
1844 1844 1613 1613 Because Music 68
2524 2524 2200 2200 Because Music 68
3540 3540 3088 3088 Because Music 68
4141 4141 3625 3625 Because Music 68
5140 5140 4496 4496 Because Music 68
5542 5542 4825 4825 Because Music 68
5550 5550 4832 4832 Because Music 68
7000 7000 6095 6095 Because Music 68
7424 7424 6458 6458 Because Music 68
7814 7814 6801 6801 Because Music 68
8234 8234 7174 7174 Because Music 68
8862 8862 7736 7736 Because Music 68
9852 9852 8618 8618 Because Music 68
11906 11906 10419 10419 Because Music 68
12452 12452 10923 10923 Because Music 68
12548 12548 11008 11008 Because Music 68
29550 29550 26641 26641 Because Music 68
29672 29672 26747 26747 Because Music 68
30402 30402 27394 27394 Because Music 68
30461 30461 27447 27447 Because Music 68

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