home / pf

albums_labels

8 rows where label_id = 2206

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8098 8098 7053 7053 2062 2206
12995 12995 11417 11417 2062 2206
21302 21302 18989 18989 2062 2206
22013 22013 19637 19637 2062 2206
23163 23163 20694 20694 2062 2206
24466 24466 21927 21927 2062 2206
24467 24467 21928 21928 2062 2206
25508 25508 22921 22921 2062 2206

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