home / pf

albums_labels

7 rows where label_id = 513

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
951 951 811 811 Rise 513
2627 2627 2290 2290 Rise 513
4792 4792 4185 4185 Rise 513
6452 6452 5613 5613 Rise 513
7595 7595 6611 6611 Rise 513
8851 8851 7726 7726 Rise 513
10221 10221 8944 8944 Rise 513

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