home / pf

albums_labels

9 rows where label_id = 415

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
704 704 594 594 Verve Forecast 415
3499 3499 3058 3058 Verve Forecast 415
4399 4399 3839 3839 Verve Forecast 415
17754 17754 15693 15693 Verve Forecast 415
19861 19861 17702 17702 Verve Forecast 415
22096 22096 19714 19714 Verve Forecast 415
22260 22260 19865 19865 Verve Forecast 415
22523 22523 20100 20100 Verve Forecast 415
29205 29205 26343 26343 Verve Forecast 415

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