home / pf

albums_labels

8 rows where label_id = 331

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
522 522 438 438 Parkwood Entertainment 331
3064 3064 2682 2682 Parkwood Entertainment 331
4739 4739 4135 4135 Parkwood Entertainment 331
5922 5922 5163 5163 Parkwood Entertainment 331
6301 6301 5486 5486 Parkwood Entertainment 331
9178 9178 8027 8027 Parkwood Entertainment 331
29435 29435 26538 26538 Parkwood Entertainment 331
30455 30455 27442 27442 Parkwood Entertainment 331

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