home / pf

albums_labels

7 rows where label_id = 1459

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4321 4321 3772 3772 Heavy on the Grind 1459
6220 6220 5415 5415 Heavy on the Grind 1459
8241 8241 7180 7180 Heavy on the Grind 1459
12421 12421 10893 10893 Heavy on the Grind 1459
14708 14708 12990 12990 Heavy on the Grind 1459
16066 16066 14186 14186 Heavy on the Grind 1459
16068 16068 14187 14187 Heavy on the Grind 1459

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