home / pf

albums_labels

9 rows where label_id = 1074

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2716 2716 2370 2370 Godmode 1074
4248 4248 3715 3715 Godmode 1074
5749 5749 5004 5004 Godmode 1074
6821 6821 5947 5947 Godmode 1074
7768 7768 6762 6762 Godmode 1074
11630 11630 10178 10178 Godmode 1074
11785 11785 10317 10317 Godmode 1074
12565 12565 11024 11024 Godmode 1074
14885 14885 13145 13145 Godmode 1074

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