home / pf

albums_labels

7 rows where label_id = 4857

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
26845 26845 24200 24200 Force Inc 4857
27246 27246 24563 24563 Force Inc 4857
27377 27377 24689 24689 Force Inc 4857
27742 27742 25029 25029 Force Inc 4857
28182 28182 25431 25431 Force Inc 4857
28242 28242 25486 25486 Force Inc 4857
28948 28948 26127 26127 Force Inc 4857

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