home / pf

albums_labels

13 rows where label_id = 504

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
925 925 788 788 Get Better 504
1199 1199 1033 1033 Get Better 504
1646 1646 1431 1431 Get Better 504
2110 2110 1837 1837 Get Better 504
2388 2388 2078 2078 Get Better 504
3441 3441 3008 3008 Get Better 504
4189 4189 3666 3666 Get Better 504
4664 4664 4071 4071 Get Better 504
4727 4727 4125 4125 Get Better 504
4925 4925 4304 4304 Get Better 504
6259 6259 5449 5449 Get Better 504
30131 30131 27151 27151 Get Better 504
30335 30335 27334 27334 Get Better 504

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