home / pf

albums_labels

6 rows where label_id = 2991

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13329 13329 11729 11729 50 Weapons 2991
13533 13533 11917 11917 50 Weapons 2991
14026 14026 12362 12362 50 Weapons 2991
14749 14749 13028 13028 50 Weapons 2991
15017 15017 13261 13261 50 Weapons 2991
15555 15555 13742 13742 50 Weapons 2991

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