home / pf

albums_labels

7 rows where label_id = 3589

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17929 17929 15861 15861 Minty Fresh 3589
20283 20283 18062 18062 Minty Fresh 3589
20947 20947 18663 18663 Minty Fresh 3589
24494 24494 21953 21953 Minty Fresh 3589
24948 24948 22384 22384 Minty Fresh 3589
25335 25335 22758 22758 Minty Fresh 3589
28063 28063 25327 25327 Minty Fresh 3589

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