home / pf

albums_labels

12 rows where label_id = 1073

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2713 2713 2368 2368 Polo Grounds Music 1073
6011 6011 5242 5242 Polo Grounds Music 1073
7125 7125 6203 6203 Polo Grounds Music 1073
7165 7165 6238 6238 Polo Grounds Music 1073
7203 7203 6269 6269 Polo Grounds Music 1073
8334 8334 7264 7264 Polo Grounds Music 1073
9181 9181 8029 8029 Polo Grounds Music 1073
10460 10460 9154 9154 Polo Grounds Music 1073
11046 11046 9670 9670 Polo Grounds Music 1073
12855 12855 11290 11290 Polo Grounds Music 1073
13764 13764 12127 12127 Polo Grounds Music 1073
14999 14999 13244 13244 Polo Grounds Music 1073

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