home / pf

albums_labels

6 rows where label_id = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
76 76 68 68 Brownswood 67
3524 3524 3077 3077 Brownswood 67
6132 6132 5332 5332 Brownswood 67
7834 7834 6817 6817 Brownswood 67
14101 14101 12429 12429 Brownswood 67
14910 14910 13165 13165 Brownswood 67

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