home / pf

albums_labels

11 rows where label_id = 1722

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5577 5577 4855 4855 Anthology Recordings 1722
5578 5578 4856 4856 Anthology Recordings 1722
5579 5579 4857 4857 Anthology Recordings 1722
6809 6809 5936 5936 Anthology Recordings 1722
6810 6810 5937 5937 Anthology Recordings 1722
6811 6811 5938 5938 Anthology Recordings 1722
9247 9247 8088 8088 Anthology Recordings 1722
9248 9248 8089 8089 Anthology Recordings 1722
9249 9249 8090 8090 Anthology Recordings 1722
10538 10538 9223 9223 Anthology Recordings 1722
11939 11939 10447 10447 Anthology Recordings 1722

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