home / pf

albums_labels

6 rows where label_id = 2389

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9188 9188 8035 8035 Easy Sound 2389
10647 10647 9317 9317 Easy Sound 2389
10741 10741 9400 9400 Easy Sound 2389
10966 10966 9601 9601 Easy Sound 2389
11310 11310 9893 9893 Easy Sound 2389
11933 11933 10442 10442 Easy Sound 2389

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