home / pf

albums_labels

8 rows where label_id = 1377

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3908 3908 3415 3415 Palace 1377
11392 11392 9965 9965 Palace 1377
22269 22269 19872 19872 Palace 1377
26948 26948 24295 24295 Palace 1377
28426 28426 25659 25659 Palace 1377
28476 28476 25704 25704 Palace 1377
28595 28595 25811 25811 Palace 1377
28951 28951 26130 26130 Palace 1377

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