home / pf

albums_labels

15 rows where label_id = 1174

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3108 3108 2715 2715 Secret City 1174
3755 3755 3276 3276 Secret City 1174
9192 9192 8039 8039 Secret City 1174
11849 11849 10368 10368 Secret City 1174
14914 14914 13168 13168 Secret City 1174
15735 15735 13893 13893 Secret City 1174
16671 16671 14717 14717 Secret City 1174
17458 17458 15423 15423 Secret City 1174
17738 17738 15679 15679 Secret City 1174
18675 18675 16558 16558 Secret City 1174
19573 19573 17420 17420 Secret City 1174
20253 20253 18035 18035 Secret City 1174
20585 20585 18340 18340 Secret City 1174
21300 21300 18987 18987 Secret City 1174
29541 29541 26633 26633 Secret City 1174

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