home / pf

albums_labels

19 rows where label_id = 420

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
716 716 604 604 G.O.O.D. Music 420
868 868 741 741 G.O.O.D. Music 420
1626 1626 1412 1412 G.O.O.D. Music 420
3104 3104 2712 2712 G.O.O.D. Music 420
3712 3712 3235 3235 G.O.O.D. Music 420
5469 5469 4760 4760 G.O.O.D. Music 420
5891 5891 5135 5135 G.O.O.D. Music 420
5957 5957 5193 5193 G.O.O.D. Music 420
5983 5983 5218 5218 G.O.O.D. Music 420
6028 6028 5255 5255 G.O.O.D. Music 420
6117 6117 5322 5322 G.O.O.D. Music 420
6385 6385 5558 5558 G.O.O.D. Music 420
6677 6677 5812 5812 G.O.O.D. Music 420
7352 7352 6393 6393 G.O.O.D. Music 420
7980 7980 6946 6946 G.O.O.D. Music 420
8885 8885 7756 7756 G.O.O.D. Music 420
9419 9419 8236 8236 G.O.O.D. Music 420
9484 9484 8294 8294 G.O.O.D. Music 420
9671 9671 8457 8457 G.O.O.D. Music 420

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.795ms