home / pf

albums_labels

7 rows where label_id = 347

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
563 563 472 472 Nice Life 347
2838 2838 2474 2474 Nice Life 347
4725 4725 4124 4124 Nice Life 347
5964 5964 5199 5199 Nice Life 347
8355 8355 7280 7280 Nice Life 347
8439 8439 7352 7352 Nice Life 347
29941 29941 26977 26977 Nice Life 347

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