home / pf

albums_labels

8 rows where label_id = 1649

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5147 5147 4500 4500 Asian Man 1649
5149 5149 4501 4501 Asian Man 1649
5151 5151 4502 4502 Asian Man 1649
19880 19880 17718 17718 Asian Man 1649
23679 23679 21182 21182 Asian Man 1649
26177 26177 23561 23561 Asian Man 1649
28060 28060 25324 25324 Asian Man 1649
28203 28203 25450 25450 Asian Man 1649

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