home / pf

albums_labels

5 rows where label_id = 4419

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
23599 23599 21109 21109 Sympathy for the Record Industry 4419
24696 24696 22139 22139 Sympathy for the Record Industry 4419
27495 27495 24799 24799 Sympathy for the Record Industry 4419
27615 27615 24911 24911 Sympathy for the Record Industry 4419
28299 28299 25539 25539 Sympathy for the Record Industry 4419

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