home / pf

albums_labels

13 rows where label_id = 336

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
543 543 455 455 Fantasy 336
1462 1462 1268 1268 Fantasy 336
2221 2221 1933 1933 Fantasy 336
2355 2355 2048 2048 Fantasy 336
4480 4480 3911 3911 Fantasy 336
4735 4735 4132 4132 Fantasy 336
5802 5802 5054 5054 Fantasy 336
10354 10354 9059 9059 Fantasy 336
12389 12389 10862 10862 Fantasy 336
15745 15745 13902 13902 Fantasy 336
17258 17258 15254 15254 Fantasy 336
20191 20191 17985 17985 Fantasy 336
21941 21941 19567 19567 Fantasy 336

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