home / pf

albums_labels

20 rows where label_id = 2425

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9415 9415 8232 8232 Software 2425
9936 9936 8690 8690 Software 2425
10677 10677 9345 9345 Software 2425
11397 11397 9969 9969 Software 2425
11828 11828 10351 10351 Software 2425
11885 11885 10401 10401 Software 2425
12189 12189 10675 10675 Software 2425
12497 12497 10963 10963 Software 2425
12731 12731 11178 11178 Software 2425
13228 13228 11634 11634 Software 2425
13265 13265 11670 11670 Software 2425
13496 13496 11884 11884 Software 2425
13545 13545 11928 11928 Software 2425
13727 13727 12091 12091 Software 2425
13826 13826 12182 12182 Software 2425
14321 14321 12644 12644 Software 2425
14443 14443 12759 12759 Software 2425
14978 14978 13225 13225 Software 2425
15276 15276 13493 13493 Software 2425
15898 15898 14036 14036 Software 2425

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