home / pf

albums_labels

6 rows where label_id = 405

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
685 685 575 575 Psychic Hotline 405
778 778 659 659 Psychic Hotline 405
1299 1299 1114 1114 Psychic Hotline 405
29359 29359 26474 26474 Psychic Hotline 405
30071 30071 27094 27094 Psychic Hotline 405
30406 30406 27398 27398 Psychic Hotline 405

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