home / pf

albums_labels

6 rows where label_id = 2637

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10809 10809 9460 9460 Old Flame 2637
12722 12722 11169 11169 Old Flame 2637
14883 14883 13143 13143 Old Flame 2637
15398 15398 13606 13606 Old Flame 2637
16320 16320 14414 14414 Old Flame 2637
16996 16996 15016 15016 Old Flame 2637

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