home / pf

albums_labels

7 rows where label_id = 2766

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11733 11733 10269 10269 Brille 2766
13385 13385 11779 11779 Brille 2766
16521 16521 14590 14590 Brille 2766
17415 17415 15385 15385 Brille 2766
17772 17772 15710 15710 Brille 2766
21539 21539 19205 19205 Brille 2766
22872 22872 20421 20421 Brille 2766

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