home / pf

albums_labels

6 rows where label_id = 708

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1507 1507 1306 1306 Feeding Tube 708
3093 3093 2705 2705 Feeding Tube 708
3909 3909 3416 3416 Feeding Tube 708
5197 5197 4535 4535 Feeding Tube 708
8022 8022 6984 6984 Feeding Tube 708
15104 15104 13339 13339 Feeding Tube 708

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