home / pf

albums_labels

7 rows where label_id = 3863

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19738 19738 17583 17583 Durtro 3863
19739 19739 17584 17584 Durtro 3863
22357 22357 19951 19951 Durtro 3863
22466 22466 20049 20049 Durtro 3863
23003 23003 20545 20545 Durtro 3863
25363 25363 22786 22786 Durtro 3863
25729 25729 23134 23134 Durtro 3863

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