home / pf

albums_labels

6 rows where label_id = 1670

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5268 5268 4595 4595 Epic 1670
5325 5325 4639 4639 Epic 1670
5389 5389 4694 4694 Epic 1670
5460 5460 4755 4755 Epic 1670
5843 5843 5092 5092 Epic 1670
7090 7090 6175 6175 Epic 1670

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