home / pf

albums_labels

6 rows where label_id = 1596

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4952 4952 4327 4327 Clone 1596
12420 12420 10892 10892 Clone 1596
13760 13760 12124 12124 Clone 1596
14522 14522 12829 12829 Clone 1596
15102 15102 13336 13336 Clone 1596
26863 26863 24216 24216 Clone 1596

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