home / pf

albums_labels

14 rows where label_id = 2498

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9860 9860 8624 8624 Up 2498
11205 11205 9804 9804 Up 2498
11208 11208 9805 9805 Up 2498
22465 22465 20048 20048 Up 2498
25924 25924 23321 23321 Up 2498
27091 27091 24422 24422 Up 2498
27372 27372 24684 24684 Up 2498
28428 28428 25661 25661 Up 2498
28642 28642 25854 25854 Up 2498
28681 28681 25886 25886 Up 2498
28881 28881 26070 26070 Up 2498
28905 28905 26091 26091 Up 2498
28981 28981 26158 26158 Up 2498
28991 28991 26165 26165 Up 2498

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