home / pf

albums_labels

4 rows where album_id = 5264

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6040 6040 5264 5264 Quality Control 120
6041 6041 5264 5264 Motown 121
6042 6042 5264 5264 Capitol 112
6043 6043 5264 5264 Wolfpack Global 163

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