home / pf

albums_labels

13 rows where label_id = 3063

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13882 13882 12235 12235 Type 3063
14520 14520 12827 12827 Type 3063
14975 14975 13223 13223 Type 3063
15007 15007 13252 13252 Type 3063
17543 17543 15501 15501 Type 3063
17647 17647 15594 15594 Type 3063
17868 17868 15801 15801 Type 3063
18353 18353 16259 16259 Type 3063
18650 18650 16533 16533 Type 3063
19592 19592 17439 17439 Type 3063
21622 21622 19279 19279 Type 3063
21838 21838 19474 19474 Type 3063
24890 24890 22326 22326 Type 3063

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