home / pf

albums_labels

9 rows where label_id = 4205

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21835 21835 19471 19471 Bubble Core 4205
23952 23952 21441 21441 Bubble Core 4205
25737 25737 23141 23141 Bubble Core 4205
25959 25959 23352 23352 Bubble Core 4205
26538 26538 23907 23907 Bubble Core 4205
26639 26639 24006 24006 Bubble Core 4205
27404 27404 24714 24714 Bubble Core 4205
28215 28215 25462 25462 Bubble Core 4205
28449 28449 25681 25681 Bubble Core 4205

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