home / pf

albums_labels

5 rows where label_id = 2748

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11641 11641 10189 10189 Audraglint 2748
13045 13045 11460 11460 Audraglint 2748
13971 13971 12314 12314 Audraglint 2748
15911 15911 14047 14047 Audraglint 2748
17202 17202 15202 15202 Audraglint 2748

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