home / pf

albums_labels

8 rows where label_id = 4334

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22840 22840 20392 20392 Gern Blandsten 4334
26518 26518 23888 23888 Gern Blandsten 4334
26796 26796 24155 24155 Gern Blandsten 4334
27409 27409 24719 24719 Gern Blandsten 4334
27660 27660 24954 24954 Gern Blandsten 4334
28183 28183 25432 25432 Gern Blandsten 4334
28274 28274 25515 25515 Gern Blandsten 4334
28744 28744 25945 25945 Gern Blandsten 4334

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