home / pf

albums_labels

6 rows where label_id = 4751

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
26118 26118 23505 23505 Kinetic 4751
27300 27300 24615 24615 Kinetic 4751
27505 27505 24809 24809 Kinetic 4751
27840 27840 25119 25119 Kinetic 4751
28703 28703 25908 25908 Kinetic 4751
28796 28796 25992 25992 Kinetic 4751

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