home / pf

albums_labels

16 rows where label_id = 153

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
186 186 162 162 Griselda 153
255 255 220 220 Griselda 153
586 586 492 492 Griselda 153
1016 1016 869 869 Griselda 153
1526 1526 1323 1323 Griselda 153
1528 1528 1324 1324 Griselda 153
1951 1951 1704 1704 Griselda 153
2087 2087 1817 1817 Griselda 153
2417 2417 2105 2105 Griselda 153
2644 2644 2306 2306 Griselda 153
2765 2765 2409 2409 Griselda 153
2796 2796 2437 2437 Griselda 153
2905 2905 2534 2534 Griselda 153
3347 3347 2924 2924 Griselda 153
5838 5838 5088 5088 Griselda 153
30049 30049 27075 27075 Griselda 153

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