home / pf

albums_labels

33 rows where label_id = 987

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2400 2400 2088 2088 Tompkins Square 987
6279 6279 5466 5466 Tompkins Square 987
6501 6501 5655 5655 Tompkins Square 987
7664 7664 6674 6674 Tompkins Square 987
8549 8549 7454 7454 Tompkins Square 987
8929 8929 7796 7796 Tompkins Square 987
10472 10472 9164 9164 Tompkins Square 987
11061 11061 9681 9681 Tompkins Square 987
11371 11371 9946 9946 Tompkins Square 987
11619 11619 10168 10168 Tompkins Square 987
12442 12442 10913 10913 Tompkins Square 987
13887 13887 12240 12240 Tompkins Square 987
14671 14671 12957 12957 Tompkins Square 987
15447 15447 13648 13648 Tompkins Square 987
15709 15709 13868 13868 Tompkins Square 987
15890 15890 14028 14028 Tompkins Square 987
16020 16020 14144 14144 Tompkins Square 987
16460 16460 14534 14534 Tompkins Square 987
16713 16713 14753 14753 Tompkins Square 987
17090 17090 15105 15105 Tompkins Square 987
17709 17709 15654 15654 Tompkins Square 987
17881 17881 15814 15814 Tompkins Square 987
18336 18336 16242 16242 Tompkins Square 987
19160 19160 17013 17013 Tompkins Square 987
19161 19161 17014 17014 Tompkins Square 987
19837 19837 17678 17678 Tompkins Square 987
19927 19927 17759 17759 Tompkins Square 987
20759 20759 18494 18494 Tompkins Square 987
21197 21197 18894 18894 Tompkins Square 987
21719 21719 19369 19369 Tompkins Square 987
22115 22115 19732 19732 Tompkins Square 987
22604 22604 20176 20176 Tompkins Square 987
22968 22968 20510 20510 Tompkins Square 987

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