home / pf

albums_labels

7 rows where label_id = 2122

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7642 7642 6653 6653 Invada 2122
16463 16463 14536 14536 Invada 2122
17758 17758 15696 15696 Invada 2122
18045 18045 15969 15969 Invada 2122
20884 20884 18606 18606 Invada 2122
29508 29508 26605 26605 Invada 2122
29727 29727 26792 26792 Invada 2122

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