home / pf

albums_labels

4 rows where label_id = 3339

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16009 16009 14133 14133 Dare to Care 3339
18990 18990 16843 16843 Dare to Care 3339
20779 20779 18511 18511 Dare to Care 3339
22150 22150 19764 19764 Dare to Care 3339

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