home / pf

albums_labels

6 rows where label_id = 614

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1209 1209 1042 1042 Running Back 614
7069 7069 6156 6156 Running Back 614
8070 8070 7026 7026 Running Back 614
9280 9280 8114 8114 Running Back 614
10528 10528 9214 9214 Running Back 614
15694 15694 13854 13854 Running Back 614

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