home / pf

albums_labels

11 rows where label_id = 1373

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3895 3895 3404 3404 Audika 1373
7759 7759 6755 6755 Audika 1373
9201 9201 8046 8046 Audika 1373
10429 10429 9124 9124 Audika 1373
19350 19350 17202 17202 Audika 1373
21811 21811 19449 19449 Audika 1373
21944 21944 19570 19570 Audika 1373
22832 22832 20385 20385 Audika 1373
23828 23828 21324 21324 Audika 1373
25677 25677 23082 23082 Audika 1373
29715 29715 26782 26782 Audika 1373

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