home / pf

albums_labels

6 rows where label_id = 3661

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18526 18526 16422 16422 Language of Stone 3661
19526 19526 17376 17376 Language of Stone 3661
19866 19866 17707 17707 Language of Stone 3661
19893 19893 17730 17730 Language of Stone 3661
20001 20001 17825 17825 Language of Stone 3661
20649 20649 18397 18397 Language of Stone 3661

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