home / pf

albums_labels

8 rows where label_id = 2913

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12639 12639 11095 11095 Hear Music 2913
14549 14549 12851 12851 Hear Music 2913
16097 16097 14213 14213 Hear Music 2913
17922 17922 15854 15854 Hear Music 2913
18600 18600 16490 16490 Hear Music 2913
20309 20309 18087 18087 Hear Music 2913
21309 21309 18996 18996 Hear Music 2913
24516 24516 21973 21973 Hear Music 2913

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