home / pf

albums_labels

13 rows where label_id = 3373

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16294 16294 14391 14391 Sounds Familyre 3373
16381 16381 14465 14465 Sounds Familyre 3373
17184 17184 15189 15189 Sounds Familyre 3373
17628 17628 15576 15576 Sounds Familyre 3373
21435 21435 19113 19113 Sounds Familyre 3373
22184 22184 19795 19795 Sounds Familyre 3373
24687 24687 22131 22131 Sounds Familyre 3373
25587 25587 22994 22994 Sounds Familyre 3373
25903 25903 23301 23301 Sounds Familyre 3373
26063 26063 23453 23453 Sounds Familyre 3373
26997 26997 24339 24339 Sounds Familyre 3373
27753 27753 25039 25039 Sounds Familyre 3373
28066 28066 25329 25329 Sounds Familyre 3373

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