home / pf

albums_labels

4 rows where label_id = 3461

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16965 16965 14986 14986 One Percent Press 3461
18434 18434 16336 16336 One Percent Press 3461
20244 20244 18027 18027 One Percent Press 3461
22338 22338 19933 19933 One Percent Press 3461

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