home / pf

albums_labels

5 rows where label_id = 4661

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
25484 25484 22899 22899 Rubric 4661
26687 26687 24051 24051 Rubric 4661
26870 26870 24223 24223 Rubric 4661
27925 27925 25198 25198 Rubric 4661
28553 28553 25772 25772 Rubric 4661

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