home / pf

albums_labels

7 rows where label_id = 1399

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4012 4012 3510 3510 Factory 1399
11216 11216 9811 9811 Factory 1399
20736 20736 18475 18475 Factory 1399
20737 20737 18476 18476 Factory 1399
20738 20738 18477 18477 Factory 1399
23713 23713 21213 21213 Factory 1399
26228 26228 23609 23609 Factory 1399

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