home / pf

albums_labels

8 rows where label_id = 1225

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3319 3319 2900 2900 Tough Love 1225
7614 7614 6630 6630 Tough Love 1225
8076 8076 7031 7031 Tough Love 1225
9375 9375 8197 8197 Tough Love 1225
12301 12301 10780 10780 Tough Love 1225
12371 12371 10845 10845 Tough Love 1225
14788 14788 13059 13059 Tough Love 1225
16003 16003 14127 14127 Tough Love 1225

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