home / pf

albums_labels

15 rows where label_id = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
67 67 60 60 Backwoodz Studioz 58
215 215 184 184 Backwoodz Studioz 58
674 674 566 566 Backwoodz Studioz 58
929 929 791 791 Backwoodz Studioz 58
2167 2167 1885 1885 Backwoodz Studioz 58
2440 2440 2126 2126 Backwoodz Studioz 58
3145 3145 2750 2750 Backwoodz Studioz 58
4040 4040 3537 3537 Backwoodz Studioz 58
4786 4786 4179 4179 Backwoodz Studioz 58
5624 5624 4894 4894 Backwoodz Studioz 58
6797 6797 5925 5925 Backwoodz Studioz 58
7846 7846 6829 6829 Backwoodz Studioz 58
12890 12890 11320 11320 Backwoodz Studioz 58
29274 29274 26402 26402 Backwoodz Studioz 58
29546 29546 26638 26638 Backwoodz Studioz 58

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