home / pf

albums_labels

5 rows where label_id = 985

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2398 2398 2087 2087 Pro Era 985
5225 5225 4560 4560 Pro Era 985
7721 7721 6719 6719 Pro Era 985
9809 9809 8580 8580 Pro Era 985
10940 10940 9575 9575 Pro Era 985

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