home / pf

albums_labels

23 rows where label_id = 1628

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5094 5094 4453 4453 Underwater Peoples 1628
11609 11609 10158 10158 Underwater Peoples 1628
13005 13005 11426 11426 Underwater Peoples 1628
13459 13459 11849 11849 Underwater Peoples 1628
13638 13638 12011 12011 Underwater Peoples 1628
14221 14221 12545 12545 Underwater Peoples 1628
14375 14375 12694 12694 Underwater Peoples 1628
14464 14464 12775 12775 Underwater Peoples 1628
14824 14824 13095 13095 Underwater Peoples 1628
14941 14941 13194 13194 Underwater Peoples 1628
14995 14995 13241 13241 Underwater Peoples 1628
14996 14996 13242 13242 Underwater Peoples 1628
15361 15361 13571 13571 Underwater Peoples 1628
15459 15459 13658 13658 Underwater Peoples 1628
15704 15704 13863 13863 Underwater Peoples 1628
15726 15726 13884 13884 Underwater Peoples 1628
16055 16055 14177 14177 Underwater Peoples 1628
16083 16083 14200 14200 Underwater Peoples 1628
16457 16457 14531 14531 Underwater Peoples 1628
16868 16868 14900 14900 Underwater Peoples 1628
17566 17566 15522 15522 Underwater Peoples 1628
17815 17815 15751 15751 Underwater Peoples 1628
18550 18550 16444 16444 Underwater Peoples 1628

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